Count if.

**amirshaneh** · 11-07-2011, 06:21 AM

hello guys.

im not really sure if its possible but i want to ask anyway.

i got a row that contain a full year and it changes a day each 24 rows.. with the formula
=40855+INT((ROWS($A$2:A2)-1)/24)

i wanna know if there is an option to do a montly check on how many times a certain word is apeared in another certain row and i need it to count it montly.
for example if in the current month it shows that word 18 time out of the whole month so it will show 18 in the count.

its pretty complecated for me to explain so i attached an example on how it should look.

i really hope its possible.
thanks in advance.
Amir.

**zbor** · 11-07-2011, 06:39 AM

What word you looking for?

maybe this: =COUNTIF(B1:B10000, TRUE())

**amirshaneh** · 11-07-2011, 06:47 AM

thank you for the quick response.
ive managed to get it working as i wanted it to be with the text and all.
but i think the formula that im looking for is more complicated because i need it to count only the current month