| 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 |
| 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 | |||
Threaded Mode
