Get instant live Excel expert help with a COUNTIF Functions

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

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!

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

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".

Countif not working. Help!

COUNTIF Formula not counting, need to count occurance of a phrase in cell with multiple phrases

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.

use a countif, averageif and excel if else to calculate the number of breeds

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

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?