Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DSUM | Excel Worksheet Functions | |||
DSUM | Excel Discussion (Misc queries) | |||
Using DSUM | Excel Worksheet Functions | |||
dsum | New Users to Excel | |||
DSUM | Excel Worksheet Functions |