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??
--
carolyn

=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)

"carolyn" wrote in message
...
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??
--
carolyn