| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum w/o using the Wizard.
When I use this formula, I get a #VALUE error.
=SUM(IF(I9:I17="aaa",K9:K17,0)) I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells K9 thru K17 for each occurance of "aaa" in cells I9 thru I17. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum w/o using the Wizard.
How about =sumif()
=sumif(i9:i17,"aaa",k9:k17) ron wrote: When I use this formula, I get a #VALUE error. =SUM(IF(I9:I17="aaa",K9:K17,0)) I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells K9 thru K17 for each occurance of "aaa" in cells I9 thru I17. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum w/o using the Wizard.
=SUM(IF(I9:I17="aaa",K9:K17))
press ctrl+shift+enter, not just enter "ron" wrote: When I use this formula, I get a #VALUE error. =SUM(IF(I9:I17="aaa",K9:K17,0)) I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells K9 thru K17 for each occurance of "aaa" in cells I9 thru I17. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum w/o using the Wizard.
What a simple thing. Thanks to you both.
"ron" wrote: When I use this formula, I get a #VALUE error. =SUM(IF(I9:I17="aaa",K9:K17,0)) I want to look for "aaa" in cells I9 thur I17 and sum the numbers in cells K9 thru K17 for each occurance of "aaa" in cells I9 thru I17. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum Wizard - Where is it in 2007 | Excel Discussion (Misc queries) | |||
| Conditional sum wizard problem--Excel 2000 | Excel Discussion (Misc queries) | |||
| Conditional Sum Wizard Error | Excel Discussion (Misc queries) | |||
| Conditional Sum Wizard | Excel Worksheet Functions | |||
| using wizard and conditional sum | Excel Worksheet Functions | |||
Linear Mode
