Sumproduct with if and or condition

[Diddy]

Hi,

I've got this formula

=SUMPRODUCT(--($H$1:$H$1016=5),--($I$1:$I$1016=5),--($J$1:$J$1016=5)) so that it counts the number of records where there is a 5 in each of the columns H I and J.

If anyone could help me change this to include another condition that would be great

I would like to be able to count records where there is a 5 in both H and I but additionally either a 5 in J and or K

Hopefully this makes some sense

Cheers
Diddy

[Colin Legg]

Hi,

When you're working with arrays, * gives an AND condition whilst + gives an OR condition. So a variation like these:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Diddy]

Never said thank you - sorry much appreciated