| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching column criteria in a one to many relationship | Excel Worksheet Functions | |||
| Four criteria MATCH INDEX lookup of date between matching two text | Excel Worksheet Functions | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Linear Mode
