Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Coverting data in a one column into a single row | Excel Discussion (Misc queries) | |||
Viewing data from one column within one single cell ? | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) |