When I first use the Conditional Sum Wizard, I get an error "Your range
contains one or more entries using randomized numbers...."

If I change the formatting of the range that the Wizard is operating on, I
do not get the error.

Any ideas why the wizard cares about my formatting (which is Accounting)?

Thanks,
Charlie Rowe