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.
