Thread: Count IF

I am using a count if to look at a column C in a worksheet a and return how many time the word 'on test' occurs. This is then returned to a table in another worksheet. I have 5 worksheets in total with the same columns, how can I do multiple countif - so that it will count all the 'on test' in column C for all 5 sheets

Thanks

unfortunatly count if wont work across multiple sheet you could either use
=countif(sheet1!c1:c100,"on test")+countif(sheet2!c1:c100,"on test")+.......
or if you download and activate the morefunftions add in
from
http://xcell05.free.fr/english/index.html

=COUNTIF.3D(Sheet1:Sheet5!C1:C20,"ontest")