Countif multiple worksheets
 

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!

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!

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)


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

Hi Bob

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

Cheers
julieD

"Bob Phillips" wrote in message
...
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)


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

Hi Julie,

2 today, 200 tomorrow :-)

Regards

Bob


"JulieD" wrote in message
...
Hi Bob

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

Cheers
julieD

"Bob Phillips" wrote in message
...
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)


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