| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Conditional sum wizard problem--Excel 2000
(In my spreadsheet, Category is column D, Price is column E).
Category Price Paid? Core $55.50 yes ESL $20.00 yes Conditional Sum Formula for "Core": =SUM(IF($D$2:$D$52="Core",$E$2:$E$52,0)) Conditional Sum Formula for "ESL":=SUM(IF($D$2:$D$52="ESL",$E$2:$E$52,0)) The ESL one works fine; the Core one doesn't!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
