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.

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.

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)

Conditional sum wizard problem--Excel 2000
 

I checked that, and there are no spaces.

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