count records with only one of multiple criteria met

[ronj56]

I have a large table with each row containing multiple values, each with a different acceptance criterion. How can I count the number of rows with at least one value over an acceptance criterion?

I have been able to make it work with only 2 criteria,

for example
(COUNTIF(Table2[Hi],">5")+COUNTIF(Table2[Med],"<3050"))-(SUMPRODUCT((Table2[Hi]>5)*(Table2[Med]<3050)))

but not with more than 2.

I expect there is a simple solution, there usually is, but I just can't get it.

Thanks for any help

[ronj56]

Don't spend any time on this. I found it.

=SUM(IF((Table2[Hi]>5)+(Table2[Med]>5)+(Table2[Lo]>5),1,0)) (CSE)

Use + for or logic and * for and logic.

[Don]

Thanks for posting your solution!

[Ourpat1]

Use a Vlookup formula..............too many if's.....always Vlookup.post example and I'll fix

Pat Savage

[Ourpat1]

Old addage......programme small.......save often..............it's only "true or "false" 1 or 2..........and hide colums that do the steps