Sun IF two data types are the same in a single column
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.
|