If two criteria match then sum matching values in another column

[Diddy]

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

 

[Mike H]

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

 

[Diddy]

Thanks Mike,

Problem solved



--
Diddy

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

 

[francis]

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

 

[Mike H]

Glad I could help

Thanks Mike,

Problem solved

 

[Diddy]

Thank you Francis

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