If two criteria match then sum matching values in another column
 

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

If two criteria match then sum matching values in another column
 

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" wrote:

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

If two criteria match then sum matching values in another colu
 

Thanks Mike,

Problem solved :-)



--
Diddy


"Mike H" wrote:

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" wrote:

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

If two criteria match then sum matching values in another column
 

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





"Diddy" wrote:

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

If two criteria match then sum matching values in another colu
 

Glad I could help


"Diddy" wrote:

Thanks Mike,

Problem solved :-)



--
Diddy


"Mike H" wrote:

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" wrote:

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

If two criteria match then sum matching values in another colu
 

Thank you Francis :-)

"francis" wrote:

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





"Diddy" wrote:

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