software

I Have Start date and end date (MMM/YY) format

what I want is for each month, a sum of records which has a start date or
end date
and between them.

For example. Feb 06 : would have all records between with Feb06 start date
or end date. and date in between ( i.e, Start date Dec 05 end date Apr 06)

try
=sumproduct((daternggt;a2)*(daternglt;=a3))
to sum
=sumproduct((daternggt;a2)*(daternglt;=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

quot;flow23quot; gt; wrote in message
news
gt;I Have Start date and end date (MMM/YY) format
gt;
gt; what I want is for each month, a sum of records which has a start date or
gt; end date
gt; and between them.
gt;
gt; For example. Feb 06 : would have all records between with Feb06 start date
gt; or end date. and date in between ( i.e, Start date Dec 05 end date Apr 06)
gt;
gt;
gt;
sorry am a bit confused.. which one of the two?quot;Don Guillettquot; wrote:

gt; try
gt; =sumproduct((daternggt;a2)*(daternglt;=a3))
gt; to sum
gt; =sumproduct((daternggt;a2)*(daternglt;=a3)rngtosum)
gt; ranges must be the same size and not entire columns.
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;flow23quot; gt; wrote in message
gt; news
gt; gt;I Have Start date and end date (MMM/YY) format
gt; gt;
gt; gt; what I want is for each month, a sum of records which has a start date or
gt; gt; end date
gt; gt; and between them.
gt; gt;
gt; gt; For example. Feb 06 : would have all records between with Feb06 start date
gt; gt; or end date. and date in between ( i.e, Start date Dec 05 end date Apr 06)
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

try em

--
Don Guillett
SalesAid Software

quot;flow23quot; gt; wrote in message
...
gt; sorry am a bit confused.. which one of the two?
gt;
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; try
gt;gt; =sumproduct((daternggt;a2)*(daternglt;=a3))
gt;gt; to sum
gt;gt; =sumproduct((daternggt;a2)*(daternglt;=a3)rngtosum)
gt;gt; ranges must be the same size and not entire columns.
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;flow23quot; gt; wrote in message
gt;gt; news
gt;gt; gt;I Have Start date and end date (MMM/YY) format
gt;gt; gt;
gt;gt; gt; what I want is for each month, a sum of records which has a start date
gt;gt; gt; or
gt;gt; gt; end date
gt;gt; gt; and between them.
gt;gt; gt;
gt;gt; gt; For example. Feb 06 : would have all records between with Feb06 start
gt;gt; gt; date
gt;gt; gt; or end date. and date in between ( i.e, Start date Dec 05 end date Apr
gt;gt; gt; 06)
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
sorry aboutt his again..but what is a2 and a3?

I have start date in column D and end date in column equot;Don Guillettquot; wrote:

gt; try
gt; =sumproduct((daternggt;a2)*(daternglt;=a3))
gt; to sum
gt; =sumproduct((daternggt;a2)*(daternglt;=a3)rngtosum)
gt; ranges must be the same size and not entire columns.
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;flow23quot; gt; wrote in message
gt; news
gt; gt;I Have Start date and end date (MMM/YY) format
gt; gt;
gt; gt; what I want is for each month, a sum of records which has a start date or
gt; gt; end date
gt; gt; and between them.
gt; gt;
gt; gt; For example. Feb 06 : would have all records between with Feb06 start date
gt; gt; or end date. and date in between ( i.e, Start date Dec 05 end date Apr 06)
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

Is there a thinking cap store in your neighborhood?

daterng a2:a200
a2 a start date put in this cell.

--
Don Guillett
SalesAid Software

quot;flow23quot; gt; wrote in message
...
gt; sorry aboutt his again..but what is a2 and a3?
gt;
gt; I have start date in column D and end date in column e
gt;
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; try
gt;gt; =sumproduct((daternggt;a2)*(daternglt;=a3))
gt;gt; to sum
gt;gt; =sumproduct((daternggt;a2)*(daternglt;=a3)rngtosum)
gt;gt; ranges must be the same size and not entire columns.
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;flow23quot; gt; wrote in message
gt;gt; news
gt;gt; gt;I Have Start date and end date (MMM/YY) format
gt;gt; gt;
gt;gt; gt; what I want is for each month, a sum of records which has a start date
gt;gt; gt; or
gt;gt; gt; end date
gt;gt; gt; and between them.
gt;gt; gt;
gt;gt; gt; For example. Feb 06 : would have all records between with Feb06 start
gt;gt; gt; date
gt;gt; gt; or end date. and date in between ( i.e, Start date Dec 05 end date Apr
gt;gt; gt; 06)
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;