Conditional sum wizard problem--Excel 2000

[lcnlit]

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.

 

[Guest]

Hi

Maybe your 'Core' has spaces at the beginning or end?

Andy.

 

[Dave O]

What do your conditional format formulas look like? These worked for
me:
=IF(D3="yes",C3,0)
=IF(B4="core",C4,0)

 

[lcnlit]

I checked that, and there are no spaces.

 

[lcnlit]

(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!!