 |
 | 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 / General Excel Questions / March 2008dsum
Here is the setup. I have three columns (Month, Day, and Number Collected) that I am trying to obtain weekly totals for by using the dsum function =DSUM(A1:C65,3,H1:I2). My criteria appear as follows: H1-Month I1-Day H2-March I2- ? I2 is were I am having trouble. If I want the formula to return the Number Collected only for March 3 through March 7 and not for collections before or after this week in March, how do I write that? I've been attempting to combine >=3 and <=7 into the cell, but I'm not sure if my "language" is correct. I appreciate any help. Thanks. Stolie Add another Day criteria: .........H...........I...........J... 1....Month.....Day.....Day 2....March.....>=3.....<=7 =DSUM(A1:C65,3,H1:J2) I find the D functions extremely convoluted to use and now days are basically obsolete. Much easier to use SUMPRODUCT although the D functions are more efficient on *large amounts* of data. SUMPRODUCT is more flexibile (IMO). =SUMPRODUCT(--(A2:A65="March"),--(B2:B65>=3),--(B2:B65<=7),C2:C65) Or, use cells to hold the criteria (sort of like DSUM): H2 = March I2 = 3 J2 = 7 =SUMPRODUCT(--(A2:A65=H2),--(B2:B65>=I2),--(B2:B65<=J2),C2:C65)  SignatureBiff Microsoft Excel MVP > Here is the setup. I have three columns (Month, Day, and Number Collected) > that I am trying to obtain weekly totals for by using the dsum function [quoted text clipped - 10 lines] > > Stolie Can't believe I didn't think of that. Thanks for the added suggestion as well, I think I'll set them both up and see which one I prefer. Your help is apprecieated. Cheers. Stolie > Add another Day criteria: > [quoted text clipped - 34 lines] > > > > Stolie You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > Can't believe I didn't think of that. Thanks for the added suggestion as > well, I think I'll set them both up and see which one I prefer. Your help [quoted text clipped - 43 lines] >> > >> > Stolie Same as Biff's plus 7 more options: http://www.freefilehosting.net/download/3e7fe |
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.