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

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

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

1. sum if it match the column criteria

2. How to sum up the data which match two criteria?

3. V-lookup and summing values if more than 1 matches criteria

4. Matching values from two columns and making a third column with the results - possible?

5. Match formula to match values in multiple columns

6. match function-second matched value

7. Need formula that Counts items matching criteria using two columns

8. conditional sum(if) data matching two (or more) separated columns

9. Match a value to multple criteria both in rows and columns

10. How can find a value using two different matching criteria?

11. summing two figures based on matching columns

12. Adding values in multiple columns matching some criteria

13. Conditional sum matching two columns and a row

14. countif = < > AND value in adjacent columns match criteria

3 post • Page:**1** of **1**