Get instant live Excel expert help with a COUNTIF Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hello,
I'm stuck on an Excel problem and I'm hoping someone can help.
I need to add the number of times the letter 'S' or 's' shows up in a column if two other cells are exact matches. I thought I could combine sum product and countif or vlook up and count if but nothing I've tried works.
Solved by E. Q. in 13 mins
I need my excel formula to display a countif criteria to any column i click on
Solved by X. H. in 14 mins
countif = b1 or b1
example countifs(a:a,b1 or b2)
Solved by A. U. in 30 mins
I am trying to countif a single cell across multiple sheets and am getting a #Value error. Can you look at my formula and tell me what is wrong?
=COUNTIF(Sheet1:Sheet21!G21,"correct")
Solved by G. F. in 16 mins
I have an excel file, I am trying to have the answer to a COUNTIF formula appear beside a certain text in a work sheet. (the row of the text will change every report).
I have used the following macro:
Sub CountDisciplines()
'
Dim row
Dim column
Dim value
column = 2
For row = 1 To 5000 Step 1
value = Cells(row, column)
If value = "Biology Total" Then
Cells(row, column + 1) = "COUNTIF(A, ""Biology"")"
End If
Next
End Sub
But for some reason it doesn’t return the answer to the COUNTIF it only puts the formula. What am I doing wrong?
Solved by F. Y. in 24 mins
i need to learn how to use countif to bring files together and get agood number
Solved by I. U. in 24 mins
I need a formula that is countif + and to count two columns and give one result.
Solved by K. F. in 24 mins
I need help with a count formula in excel which is across multiple worksheets with 2 factors.
Solved by E. W. in 24 mins
Hey,
If i have a cell range for foreg: a1:a100 and b1:b100 and i want to know if a1+b1=7 for each row and get the countif value that total 26 cells return with a total of 7. How can i get that done in excel or google sheets.
I have tried the countif and cointifs command with multiple columns but don't know how to get them to add/substract with each other. Also how to apply if and google sheets?
Thanks.
Solved by B. W. in 22 mins
I AM WORKING WITH POSTCODES. FOR EXAMPLE I HAVE 10 POSTCODES WHICH I'M TRYING TO CLASSIFY IN REGIONS.. I AM TRY TO CREATE A FORMULA LIKE THIS
IF(SUM(COUNTIF(A2,{"*M13*","*PR7*"})),"NW","")
THIS ONLY GIVES ME THE CLASSIFICATION FOR NW... HOW CAN I MAKE IT THAT A12, B23 IS SW AND C34, C35, C40 = SE
Solved by I. J. in 17 mins