General discussion

Locked

Excel97 Conditional Sum Wiz. Alternative

By SuzanneI ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel97 Conditional Sum Wiz. Alternative

by DKlippert In reply to Excel97 Conditional Sum W ...

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

Collapse -

Excel97 Conditional Sum Wiz. Alternative

by SuzanneI In reply to Excel97 Conditional Sum W ...

Poster rated this answer

Collapse -

Excel97 Conditional Sum Wiz. Alternative

by SuzanneI In reply to Excel97 Conditional Sum W ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums