Hi Natalie

one way

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

Cheers
JulieD

"Natalie" wrote in message
...
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!