How can i conjunction for example 5 sheet of MS excel in countif formula ?

Question

How can i conjunction for example 5 sheet of MS excel in countif formula ?

Answer 1

Since COUNTIF doesn't allow multiple area of cell ranges, so all you can do is to add the results from each of COUNTIF of each sheet.

e.g. you have sheet1, sheet2, sheet3, sheet4 and sheet5, and count how many "a" in the range A1:A10 of each sheet.

= COUNTIF(sheet1!A1:A10,"a") + COUNTIF(sheet2!A1:A10,"a") + COUNTIF(sheet3!A1:A10,"a") + COUNTIF(sheet4!A1:A10,"a") + COUNTIF(sheet5!A1:A10,"a")

Hope this helps.

Answer 2

Hi Xeas,

Please provide some more details of your question.

Cheers!

Guru