Discussion Locked

Excel97 Conditional Sum Wiz. Alternative

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I just set up a worksheet with somewhere around 150 conditional sums in it, for which I used the Conditional Sum Wizard. Now I might have to add another 450 conditional sums, but using the wizard is time-consuming, tedious, mind-numbing... you nameit, so I am looking for a faster way to enter these formulas.

The formula that results from the wizard looks like this:

{=SUM(IF($J$4:$J$158="Yes",$D$4:$D$158,0))}

The absolute cell references mean that it doesn't update if you copy it to another cell, and if you try to edit it, the "{}"'s go away, and you can't just type them back in. (I tried it, it turns it into a text string.)

So, does anyone know how to create Conditional Sums programatically, or are there any other alternatives?

Thanks for any help anyone can give.

3 replies

by dklippert

The characters {} are Array brackets. After you construct the formula,, rather than just the Enter key, use Ctrl+Shift+Enter.

This discussion is closed to new replies.