K
kateb
I want a formula that says...
If there is no data in column B leave the cell blank, If there is dat
in column B perform a COUNTIF function.
What I am unsure of is the way to reference the blank cells. Can
just use "" ?
What I currently have is
=IF(January!B:B="","",COUNTIF(January!B:B,"*fast*"))
This returns a blank cell even though there is data in column B. Th
answer to the COUNTIF statement is 0 so possibly this is why?! If thi
is the case I would like the cell to read 0!
Help appreciated!
Kate
:confused
If there is no data in column B leave the cell blank, If there is dat
in column B perform a COUNTIF function.
What I am unsure of is the way to reference the blank cells. Can
just use "" ?
What I currently have is
=IF(January!B:B="","",COUNTIF(January!B:B,"*fast*"))
This returns a blank cell even though there is data in column B. Th
answer to the COUNTIF statement is 0 so possibly this is why?! If thi
is the case I would like the cell to read 0!
Help appreciated!
Kate
:confused