Count cells two different criteria and consider as single value if both criteria match

Please help me i am new to excel world,

I have three columns, Column A contains patient name, Column B contains Systolic blood pressure(SBP), Column C contains Diastolic blood pressure(DBP). If systolic blood pressure is more than or equal to 140 or diastolic blood pressure is more than or equal to 90, I consider patient is having Hypertension.

I have 1000 patients. Now i want to count how many patients are having Hypertension. If a patient has both SBP>140 and DBP>90 then i want to count it as one patient.

Are you really using XL2003? If not, please amend your profile.

Try this formula:

=SUMPRODUCT(($B$1:$B$1000>=140)+($C$1:$C$1000>=90))

Hope this helps.

Pete

Well, I didn't have an example file to test it out on !!

Pete

THANKS "benishiryo" It worked like charm. And please tell me is there any way to exclude counting TEXTS in the column.

Originally Posted by Tony Valko

Try this...

=SUMPRODUCT(SIGN(ISNUMBER(B2:B1000)*(B2:B1000>=140)+ISNUMBER(C2:C1000)*(C2:C1000>=90)))

Thanks a lot this worked perfectly.....