I have a document that I think conditional sum has gotten corrupted in.
Below is an example of my problem. If I want to add up all of the emails
that Fred has made, I would make start a conditional sum with:
the column to sum: emails
the column to evaluate is: User
the value to get info from is: Fred
# User emails
1 Ted 16
2 Fred 4
3 Tom 8
4 Ben 13
5 Sally 2
6 Fred 8
7 Fred 7
8 Sally 11
9 Ben 9
10 Tom 10
Fred 19
The conditional sum should answer 19. The problem I'm having on just one
document is that it's just counting the number of times Freds name is listed:
3. I have used Conditional sum hundreds of times so I know I am entering it
correctly and have others in my company try it as well - same problem, but
again, just on one document. Has anyone seen this happen? I tried my virus
scan and nothing has shown up. Thanks in advance for any help!
T. Valko - 31 Jul 2008 22:54 GMT
If you're using the conditional sum wizard chances are pretty good the
formula is really overkill. All you need is a simple SUMIF:
=SUMIF(A1:A10,"Fred",B1:B10)

Signature
Biff
Microsoft Excel MVP
>I have a document that I think conditional sum has gotten corrupted in.
> Below is an example of my problem. If I want to add up all of the emails
[quoted text clipped - 25 lines]
> virus
> scan and nothing has shown up. Thanks in advance for any help!
hoo-dunit - 31 Jul 2008 23:12 GMT
That got it!!! I love it when it's simple. Thanks for you help T. Valko!!!
> If you're using the conditional sum wizard chances are pretty good the
> formula is really overkill. All you need is a simple SUMIF:
[quoted text clipped - 30 lines]
> > virus
> > scan and nothing has shown up. Thanks in advance for any help!
T. Valko - 31 Jul 2008 23:17 GMT
You're welcome. Thanks for the feedback!

Signature
Biff
Microsoft Excel MVP
> That got it!!! I love it when it's simple. Thanks for you help T.
> Valko!!!
[quoted text clipped - 37 lines]
>> > virus
>> > scan and nothing has shown up. Thanks in advance for any help!