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