counting across multiple worksheets

G

Guest

I am trying to count the number of occurances for a unique value (0) in a common column (F12) across multiple worksheets (Dominion1 to Dominion 19). Can't seem to find a formula that works. Any help would be appreciated

Thanks in advance

Gordon
 
P

Peo Sjoblom

One way

=SUMPRODUCT(COUNTIF(INDIRECT("'Dominion "&ROW(INDIRECT("1:19"))&"'!F12"),0))

--

Regards,

Peo Sjoblom

Gordon Walsh said:
I am trying to count the number of occurances for a unique value (0) in a
Click to expand...
common column (F12) across multiple worksheets (Dominion1 to Dominion 19).
Can't seem to find a formula that works. Any help would be appreciated.
 
G

Guest

Peo

This is great, thanks very much. Now I want to copy the formula down so that it applies to cell F13, F14...........F124 as well. How can I do this
 
P

Peo Sjoblom

=SUMPRODUCT(COUNTIF(INDIRECT("'Dominion
"&ROW(INDIRECT("1:19"))&"'!"&CELL("address",F12)),0))

--

Regards,

Peo Sjoblom

Gordon Walsh said:
Peo,

This is great, thanks very much. Now I want to copy the formula down so
Click to expand...
that it applies to cell F13, F14...........F124 as well. How can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting text same cell multiple worksheets 11
How do I count unique email addresses across multiple worksheets? 2
counting unique values across multiple worksheets 1
Require formula to search across multiple worksheets 2
COUNTIF across worksheets 3
Counting instances of data across worksheets 1
Count occurance of multiple text criteria 2
counting rows across multiple worksheets 1

Top