Am sure their is an easy answer to this !! But am trying to count the number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.

If you are counting the number of cells that contain either "Q" or "S", try
this:

=SUM(COUNTIF(H$7:H$1300,{"q","s"}))

Note: COUNTIF is NOT case sensitive

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"David_Williams_PG ()" wrote:

Am sure their is an easy answer to this !! But am trying to count the number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.

=sum(countif(H$7:H$1000="Q"),countif(H$7:H$1000)=" S")

This just counts the number of Q's and S's in the range and sums those two
values together. Should work for you.

Dave
--
Brevity is the soul of wit.


"David_Williams_PG ()" wrote:

Am sure their is an easy answer to this !! But am trying to count the number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.

BTW, if you do want to use an array formula, something like this would
address your "or" condition:

{=SUM(IF(OR(H$7:H$1300="Q",H$7:H$1300="S",1,0))}

Dave
--
Brevity is the soul of wit.


"David_Williams_PG ()" wrote:

Am sure their is an easy answer to this !! But am trying to count the number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.

=SUMPRODUCT(--(ISNUMBER(MATCH(H$7:H$1300,{"Q","S"},0))))

--
HTH

Bob Phillips

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

"David_Williams_PG" wrote in
message ...
Am sure their is an easy answer to this !! But am trying to count the
number
of times the letter Q and S appear in the samE column.

The formulae to count Q which works is as below :-

{=SUM(IF(H$7:H$1300 = "Q",1,0))}

What I would like to write for Q and S is :-

{=SUM(IF(H$7:H$1300 = "Q" or "S",1,0))}

But it does not work !!!!!!!!!

Would really appreciate any help on this,
Thanks,
David.