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.

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

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