H
hoo-dunit
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!
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!