Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |