Combine multiple Statements

[wvguy]

I am trying to combine statements

The result I am looking for is to have it look at 4 different sheets and count how many times it finds the word TEST on each sheet.

The issue I have is when I use +if both sheets have to have TEST for it to count 1. If one of the sheets doesn't have TEST it won't report the sheet that does have TEST .

example:
=IF(COUNTIF(sheet1!M3:M2501,"TEST")=0,"",COUNTIF(sheet1!M3:M2501,"TEST"))+IF(COUNTIF(sheet2!M3:M2501,"TEST")=0,"",COUNTIF(sheet2!M3:M2501,"TEST"))

Is there a way to combine those (or more) so that it counts each sheet and if one if the two doesn't have the word TEST it will still return the count from the other sheet?

Thanks for any help

 

[jeffreybrown]

Why not put in A1 =COUNTIF(M3:M250,"Test") on each sheet and then

=SUM(Sheet1:Sheet2!A1)

or

http://www.mrexcel.com/forum/showthread.php?t=530726

 

[wvguy]

Why not put in A1 =COUNTIF(M3:M250,"Test") on each sheet and then

=SUM(Sheet1:Sheet2!A1)

or

http://www.mrexcel.com/forum/showthread.php?t=530726

Yeah, That worked. Thank you. I didn't even think about doing that. I have a sheet just for Tables I use for DV I added it to that so as not to clutter the main sheets.. again Thank you

 

[jeffreybrown]

You're welcome and glad it worked for you