Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional sum wizard problem--Excel 2000
This is driving me crazy. Can anyone explain why this won't work with
the Conditional Sum Wizard? I've used the wizard many times before and can't figure out why it doesn't work this time. Category Price Paid? Core $55.50 yes If I try to sum "Price" using the criterion Paid?="yes", it works fine (i.e. I get $55.50). If I try to sum "Price" using Category="Core", it doesn't work (I get $0.00). Both "Category" and "Paid?" are formatted as text; "Price" is formatted as currency. Thanks. |
#2
|
|||
|
|||
Conditional sum wizard problem--Excel 2000
Hi
Maybe your 'Core' has spaces at the beginning or end? Andy. "lcnlit" wrote in message ups.com... This is driving me crazy. Can anyone explain why this won't work with the Conditional Sum Wizard? I've used the wizard many times before and can't figure out why it doesn't work this time. Category Price Paid? Core $55.50 yes If I try to sum "Price" using the criterion Paid?="yes", it works fine (i.e. I get $55.50). If I try to sum "Price" using Category="Core", it doesn't work (I get $0.00). Both "Category" and "Paid?" are formatted as text; "Price" is formatted as currency. Thanks. |
#3
|
|||
|
|||
Conditional sum wizard problem--Excel 2000
What do your conditional format formulas look like? These worked for
me: =IF(D3="yes",C3,0) =IF(B4="core",C4,0) |
#4
|
|||
|
|||
Conditional sum wizard problem--Excel 2000
I checked that, and there are no spaces.
|
#5
|
|||
|
|||
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!! |
Reply |
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) |