Conditional Sum Wizard - Where is it in 2007

[Guest]

I'm trying to figure out how to get the conditional sum wizard addon back
after upgrading to excel 2007. I have two columns. One are dates and
another are amounts (dollars). I want to add up the amounts for all that
have dates between a certain range, say august to september. The old wizard
was really easy. Can I get it back or do I have to make a formula manually.
If I do, how do I go about it? Thanks a lot in advance.

 

[Peo Sjoblom]

Click the file icon, select excel options and add-ins, then in the manage
box select excel add-ins, then click go and the same dialogue box that's in
previous versions open, check the add-ins you want and click OK Then in the
ribbon select formulas and to the far right you should have the conditional
sum wizard. Otherwise it is easy to get without using it (I have never used
it except for seeing what it was)

=SUMPRODUCT(--(A2:A100>=DATE(2006,1,1)),--(A2:A100<=DATE(2006,1,15)),B2:B100)

where A2:A100 holds the dates and B2:B100 the amounts, the above will sum
amounts in B where dates in A is greater than or equal to Jan 1 2006 and
less than or equal to Jan 15th 2006


Since the conditional sum wizard uses SUM and array entering this is easier
since you can enter the formula normally


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com