Sumproduct

[450nick]

Hi all!

I have a series of columns on a sheet with data in, running down the page. I'm trying to come up with a formula which does the following but I'm struggling:

- if the value in row 41 is the same as one in fixed cell $B$38, then multiply the value in this column, row 63 with row 66, and sum the result of this calculation for all columns from H:AA

Any clues??

 

[FormR]

Re: Help with a tricky SUMPRODUCT

Hi, sounds like:

=SUMPRODUCT(--(H41:AA41=$B$38),H63:AA63,H66:AA66)

 

[450nick]

Re: Help with a tricky SUMPRODUCT

Nice! Thank you sir.