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.
|