Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2008

Tip: Looking for answers? Try searching our database.

problem with conditional sum in excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hoo-dunit - 31 Jul 2008 22:26 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.