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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am using this formula "=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$4:$A$14&"'!F:F"),B2))" to gather data from several tabs but I need to combine it with this formula "=ColorCountifFunction($C$3,"BR",C4:C74,FALSE)" to count by colour is this possible i need to be able to count the colours based on the text in the box across several tabs
Solved by C. D. in 11 mins
I am trying to count the number of children in certain age groups based on a column that has calculated their age in years and month using the datedif excel formula. When I try the countif function on a separate summary worksheet, it doesn't work. Please help!
Solved by Z. H. in 25 mins
I need a formula to tell me how many cells in a column are between two numbers (e.g. 70 to 71). Have tried countif, but am likely doing it wrong. Thanks
Solved by S. Y. in 21 mins
I am trying to use the Countif formula to count the number of occurrences of a specific phrase in a specific column. I am using the formula =COUNTIF(V2:V500,"Account Closed") and the formula is reflecting "0". The case of the letters in the phrase is accurate and the same formula worked for another column in which I was searching for "Y".
Solved by G. D. in 19 mins
Countif not working. Help!
Solved by F. F. in 28 mins
COUNTIF Formula not counting, need to count occurance of a phrase in cell with multiple phrases
Solved by M. L. in 15 mins
I have three rows of data. There is one value in each row, so it looks like this: k I d k e d 0 1 0 I'd like to COUNTIF the third row only when the value is greater than zero and the two cells above the cell in the third row do not match.
Solved by M. Y. in 29 mins
use a countif, averageif and excel if else to calculate the number of breeds
Solved by A. J. in 16 mins
Hi I am trying to do a countif on a column in a different tab, where I'm entering my formula, on a spreadsheet I have. If I use the following formula: =IF(K21=TODAY(),(SUM(COUNTIFS('5 Actual Dates'!H:H,{"<=23/03/2018","Complete"}))),"") The count works. If I change the date above to a cell which contains that date i.e. =IF(K21=TODAY(),(SUM(COUNTIFS('5 Actual Dates'!H:H,{"<=K21","Complete"}))),"") It doesn't work. K21 has the date 23/03/2018 entered in it. Thanks
Solved by F. C. in 26 mins
i have the following formula working in my spread sheet: =SMALL(IF($C$1:$C$99>0,IF(COUNTIF(Tournament!$A$3:$A$17,$C$1:$C$99)=0,$C$1:$C$99)),1) However, where i currently have $A$3:$A$17, I really need it to be $A$3:$A$65 but NOT INCLUDING $A$27.... How can i do this?
Solved by M. C. in 16 mins