Help required with countif function

[Dynamo]

Hi,

Can somebody please tell me if it is possible to use the countif function across
multiple sheets without repeatedly having to use countif. At present I have the
following:

Countif(sheet1!E1:E110,D15)+Countif(sheet2!A1:A55,D15)....... and so on up to 10
sheets. Can this statement be condensed?

Any help greatly appreciated
TIA
Dynamo

 

[Peo Sjoblom]

Only if the cell ranges are the same

 

[Scott_Mariani]

Dynamo,
Have you had any success? I too have tried to use the countif accros
multiple worksheets without success. I tried th
"=countif('Sheet1:Sheet2'!...)" but kept getting a "#VALUE!" that
could not resolve. I tried the "=countif(..)+countif(..)" and tha
worked fine but it will certainly be much messier over time.
Please let me know if you were able to get it to work.
TIA Scot

 

[Peo Sjoblom]

There is a workaround, this will work

=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:3"))&"'!A2:A4"),">0"))

will count how many values greater than zero in A2:A4 for sheet1 to 3