 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Adding up a column in a worksheet
I'm having trouble figuring how to add up a column that meet a condition in Sheet1 and having the results show in Sheet 2. Example of what I'm trying to do: Month Amount Category Jan 523.00 JOB1 Jan 121.00 JOB2 Jan 75.00 JOB1 Any assistance would be greatly appreciated, Thanks, Maybe something like this: Sum of Job1 for Jan: =SUMPRODUCT(--(Sheet1!A1:A100="Jan"),--(Sheet1!C1:C100="Job1"),Sheet1!B1:B100)  SignatureBiff Microsoft Excel MVP > I'm having trouble figuring how to add up a column that meet a condition > in [quoted text clipped - 9 lines] > Any assistance would be greatly appreciated, > Thanks, Thank you > Maybe something like this: > [quoted text clipped - 15 lines] > > Any assistance would be greatly appreciated, > > Thanks, You're welcome! SignatureBiff Microsoft Excel MVP > Thank you > [quoted text clipped - 18 lines] >> > Any assistance would be greatly appreciated, >> > Thanks, You don't say what the conditions are but assuning that they are *Jan* in Column A, *JOB1* in Column C and the amount in Column B try: =SUMPRODUCT((Sheet1!A2:A20="Jan")*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20) If the *Jan* is a date formatted as mmm then use: =SUMPRODUCT((Sheet1!A2:A20<>"")*(MONTH(Sheet1!A2:A20)=1)*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20) SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > I'm having trouble figuring how to add up a column that meet a condition > in [quoted text clipped - 9 lines] > Any assistance would be greatly appreciated, > Thanks, Thank you Sandy.. > You don't say what the conditions are but assuning that they are *Jan* in > Column A, *JOB1* in Column C and the amount in Column B try: [quoted text clipped - 18 lines] > > Any assistance would be greatly appreciated, > > Thanks, |
Reply to this Message |
 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.