counting

J

JRD

A B
1 Right femoral Angioseal
2 Left Femoral Manual Pressure / TR band
3 Right Femoral Angioseal
4 Left Femoral Manual Pressure / TR band
5 Right Femoral Manual Pressure
6 Right Radial TR band

With the above cells, how do I count the number of rows in which column A
contains the word Femoral and column B in the same row contains the word
Manual? Answer : 3

Also how do I do the same but this time column A contains Femoral and column
B contains exactly Manual Pressure? Answer : 1

Thanks

John
 
M

Max

(a) Use:
=SUMPRODUCT((ISNUMBER(SEARCH("Femoral",A1:A10)))*(ISNUMBER(SEARCH("Manual",B1:B10))))

(b) Use:
=SUMPRODUCT((ISNUMBER(SEARCH("Femoral",A1:A10)))*(B1:B10="Manual Pressure"))
 
E

Elkar

For your first question:

=SUMPRODUCT(--(ISNUMBER(FIND("Femoral",A1:A6))),--(ISNUMBER(FIND("Manual",B1:B6))))

For your second question:

=SUMPRODUCT(--(ISNUMBER(FIND("Femoral",A1:A6))),--(B1:B6="Manual Pressure"))

HTH,
Elkar
 
Top