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

(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"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JRD" wrote:
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


(a)
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

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

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


"JRD" wrote:

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