Need formula for counting row once when two columns meet criteria

[ajeffres]

BP Formula.xlsxI'm not sure what formula to use or if Excel can do this. I want to use it to determine number of blood pressures in a certain range. So if I use column A for SBP (systolic BP) and column B for DBP (diastolic BP). I want a formula to tell me if column A is between 140-159 or column B is between 90-99. I can get that part, but what I'm having trouble with is it counting each row twice if both column A and B meet the criteria, whereas I want every row (person) to only be counted once if either column A OR column B meet the criteria. (See attachment) PLEASE HELP!!

[FDibbins]

Hi and welcome to the forum

Maybe something like this?

=IF(OR(and(A1>=141,A1<160),and(B1>=90,B1<100)),1,"")

You could then add up all the 1's

[ajeffres]

That works out great, I'll just add in a column for that to add up and then total it! Thank you!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

[sktneer]

If you don't want to add another column, you may try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl + Shift + Enter instead of just Enter. i.e. after placing the formula in the cell, hold down the Ctrl+Shift and then press Enter.

Please Login or Register  to view this content.

[ajeffres]

Ok, can this be tweaked a little bit for the following...
I don't want it to count if it falls outside of one of these ranges? For instance if the result would be 160 for column B and 95 for Column C then it shouldn't be counted because it's greater than the range we want for column B.