Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default dsum

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DSUM Jed Excel Worksheet Functions 0 January 8th 08 11:35 PM
DSUM sesler2 Excel Discussion (Misc queries) 12 March 7th 07 03:26 AM
Using DSUM JoeRapacilo Excel Worksheet Functions 1 March 10th 06 07:02 PM
dsum PaulOakley New Users to Excel 1 July 18th 05 04:49 PM
DSUM Tnknsnj Excel Worksheet Functions 1 June 10th 05 03:31 AM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"