Developer Forum

Hi everyone,

What I would like to be able to do is sum the values in column L when value
in column C = N2 and in Column F = 1

I'm using the formula below but it's returning a value error

=SUMPRODUCT(--($C$2:$C$10000=$N$2),--($F$2:$F$100="1"),$L$2:$L$1000)

Any suggestions appreciated

Thanks

Hi,

All your ranges must be the same size an no quotes for the 1

=SUMPRODUCT(--($C$2:$C$100=$N$2),--($F$2:$F$100=1),$L$2:$L$100)

Mike

Your range need to be of the same size when using SUMPRODUCT, and remove
the quote from 1, Excel treat it as Text. Formula look like this

=SUMPRODUCT(--($C$2:$C$10000=$N$2),--($F$2:$F$10000=1),$L$2:$L$10000)

adjust the range to suit yours.

--
Hope this is helpful

Click the Yes button below if this post work for you.


Thank You

cheers, francis