Sum Totals between 2 dates

P

Peo Sjoblom

=SUMPRODUCT(--(DateRange>=DATE(2004,4,10)),--(DateRange<=DATE(2004,5,10)),Qt
yRange)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
R

Ron Rosenfeld

in project I want to sum Work quantitees between 2 dates help please
Click to expand...

=SUMIF(DateRange, ">=" & StartDate, WorkQuantities)
- SUMIF(DateRange, ">" & EndDate, WorkQuantities)


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF between 2 dates 1
How to create a bubble chart with more than 2 variables. 0
SUMIF between date range 0
Display weeks from a Milestone 0
Multiple logic functions with multiple sums 2
Getting the Vertical SUM of a (Custom-Calculated) Duration Field?? 0
Between dates 2
Multiple IF Statement in Word 5

Top