SUMPRODUCT with 4 IF's help

[ddub25]

Can anyone help with a SUMPRODUCT asking multiple IF's?

I want it to ask IF, "bo" present in I11:I133
"c" present in L11:L133
"p" present in M11:M133
"ch" present in N11:N133

If so, SUM the corresponding row in range AQ11:AQ133.

Thanks.

Dan

 

[RichardMGreen]

It would be something like:-
=SUMPRODUCT((I11:I113="bo")*(L11:L113="c")*(M11:M113="p")*(N11:N113="ch")*(AQ11:AQ113="bo"))

You would need all four in the same row for it to sum those rows in AQ.

 

[ddub25]

thanks richard, made a few slight changes and it works fine. thanks.

Dan