Counting instances of data across worksheets

G

Guest

I am trying to count the number of times specific data occurs across multiple
worksheets in the same workbook. I thought COUNTIF would work, but I don't
seem to be able to set the range properly. basically, I want to always look
in the same cell on each worksheet and count the contents in a summary
worksheet. Any ideas??
 
B

Bob Phillips

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT("1:3"))&"!A1"),"x"))

sums Sheet1,2 and 3 where the vaklue is "x"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Excel Count If Formula Question 1
Conditional Formatting Across Spreadsheets 3
counting data across worksheets 5
Lookup Data Across Multiple Worksheets 4
counting text same cell multiple worksheets 11
Fill Data across multiple Worksheets - Formulas 1
Array across multiple worksheets 1
Summarise data from several worksheets in a workbook 2

Top