Bruce

Posts: n/a

Sum between a range of dates

I want to get the sum between a range of dates.

H8:S8 contain the dates
H11:S11 contains the values
V5 is the start date
V6 is the end date

I have tried the following as an array formula but if only works if V5 and
V6 are at least that of range H8:S8

=SUM(IF(AND(H8:S8=V5,H8:S8<=V6),H11:S11))

In other words I want it to sum the cell the do meet the criteria.

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM
Range of dates determine days	DNSNIDER	Excel Worksheet Functions	2	December 24th 04 03:07 AM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM
can I use a range of dates as a criteria when using sumif?	D@annyBoy	Excel Worksheet Functions	5	December 2nd 04 01:37 PM
I have a list of dates that I need to count based on a date range	ejb030353	Excel Worksheet Functions	4	November 24th 04 02:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us