## If two criteria match then sum matching values in another column

### 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

### 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.

--