sumif and and or logic

[dmheller]

All,
I am doing a sum(if( and then using the array to do the logic.
=SUM(IF(ISNUMBER(B5:B662),IF(INT(B5:B662)=INT(R5),--((E5:E662>220)+(F5:F662>220)+(G5:G662>220)+(H5:H662>220)>0)*(D5:D662=1))))

I want to add more logic to this. so it will be
column D =1
and
Column k<20
and
Column L<20
and
column E or F or G or H >220
and
column m or n >90

does this have to be done a curtain way or does excel get the logic of it with the + and * signs.

 

[Marcelo Branco]

To create a shorter and more efficient formula you may use helper columns.
For example, in column Y
Y5
=(MAX(E5:H5)>220)*(D5=1)
and copy down

Then instead of
(E5:E662>220)+(F5:F662>220)+(G5:G662>220)+(H5:H662>220)>0)*(D5:D662=1)
you can use
(Y5:Y662=1)

M.