Countif multiple worksheets

N

Natalie

Hi,

I have two worksheets, and I want to count all the 'S' that appear from
A1:H1 on each worksheet?

How do I? Please help!
 
J

JulieD

Hi Natalie

one way

=COUNTIF(Sheet2!A1:H1,"S")+COUNTIF(Sheet3!A1:H1,"S")

Cheers
JulieD
 
B

Bob Phillips

Another way,

=SUMPRODUCT(--(COUNTIF(INDIRECT("'"&$I$1:$I$3&"'!A1:H1"),"S")))

where I1:I3 holds a list of the sheets in the workbook (extend as required).

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

JulieD

Hi Bob

thought i would use the easy method as she said she only had two workbooks
:)

Cheers
julieD
 

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

Visio to Excel 0
Excel 2010 countifs for date range 3
Embed the same Excel multiple times 0
need help on either doing a loop and counting specific values orusing subtotal function 2
COUNTIF across worksheets 3
Syncing between source worksheet and dependent worksheets 0
Ttest across multiple worksheets 0
How to implement two shifts per day with multiple teams 0

Top