Conditional Summing

  • Thread starter Thread starter Duane Bender
  • Start date Start date
D

Duane Bender

Can anyone tell me why conditional summing has to be such
a pain!!!!!!

1. Why must you always use the Wizard to enter a
conditional sum???

2. Why can you not make any kind of a change to the
resulting formula?? It always trashes the conditional sum.

3. What kind of stupid programers are assembling Excel,
anyway, or is this just the obvious norm for Microsoft.
 
1) You don't

2) No it doesn't, unless you re-enter it incorrectly

3) Mostly pretty damn smart ones, and whilst there are numerous things that many
of us would like to see changed, we usually tend to make sure we get our facts
straight before going into any kind of rant about it.

Now, if you still want to kmow how you do what you are trying without the
wizard, then simply Array enter the formula using CTRL+SHIFT+ENTER. As long as
you have the syntax right, you will have no problems. You might also want to
read up on Array formulas:-

http://cpearson.com/excel/array.htm
 
Duane Bender said:
Can anyone tell me why conditional summing has to be such
a pain!!!!!!

1. Why must you always use the Wizard to enter a
conditional sum???
Click to expand...

You don't!
2. Why can you not make any kind of a change to the
resulting formula?? It always trashes the conditional sum.
Click to expand...

You can!
3. What kind of stupid programers are assembling Excel,
anyway, or is this just the obvious norm for Microsoft.
Click to expand...

I know who I would bet on!

How about an intelligent, reasoned question rather than a rant!
 
Thanks Ken,

Sorry for the venting of steam, sometimes after reading
and reading in help files, nothing seams to come together
or get you where you need to go.

Excel is basically a good application, which I have used
for the last 5 years, and I still find myself trying to
make a database of it.

Have a great day.
 
LOL - No problem at all. You can ask just about anything you like in these
groups, and they really are the best help files I have ever found. There's
'almost' no such thing as a dumb question, and plenty of people around to help,
so it never hurts to ask. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Duane Bender said:
Thanks Ken,

Sorry for the venting of steam, sometimes after reading
and reading in help files, nothing seams to come together
or get you where you need to go.

Excel is basically a good application, which I have used
for the last 5 years, and I still find myself trying to
make a database of it.

Have a great day.
Click to expand...
<snip>
 
Back
Top