COUNTIFS Across multiple worksheets

Hi all,

New to the forum and an average exceller (is that a word!?!). I am having a problem getting my formula to return a result. The basics are that I would like a count of a specific set of data in a section of a workbook. So in column 'A' I am searching for 'TextA' but this also has to have 'TextB' in column C. The problem is I have 12 consecutive monthly worksheets I would like to pull this data from and I only really want to write one formula. I can (and started to) use the countifs function plus countifs function etc referencing each worksheet individually but this seems long winded. I have read on this forum that I can use sumproduct combined with countifs but I can't seem to get it right. I have listed my formula for a single sheet countifs function below, but I don't know how or if to include the sumproduct function to reference the rest of the monthly worksheets. The other thing I should mention is that there are other worksheets too, so it would need to be specific to this range, but they are consecutive within the workbook.

Please Login or Register  to view this content.

Any help would be very gratefully received!

Many thanks in advance.

Regards
PalaceOzzy

Try.. =COUNTIFS('Jan 12'!A:A,"TextA",'Jan 12'!C:C,"TextB")

Hi XOR LX,

Thank you very much for your solution, it worked perfectly, so thanks for your quick response to my problem.

Regards
PalaceOzzy