“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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