count between start date and end date
 

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)

count between start date and end date
 

try
=sumproduct((daternga2)*(daterng<=a3))
to sum
=sumproduct((daternga2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
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)

count between start date and end date
 

sorry am a bit confused.. which one of the two?


"Don Guillett" wrote:

try
=sumproduct((daternga2)*(daterng<=a3))
to sum
=sumproduct((daternga2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
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)

count between start date and end date
 

try em

--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
sorry am a bit confused.. which one of the two?


"Don Guillett" wrote:

try
=sumproduct((daternga2)*(daterng<=a3))
to sum
=sumproduct((daternga2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
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)

count between start date and end date
 

sorry aboutt his again..but what is a2 and a3?

I have start date in column D and end date in column e


"Don Guillett" wrote:

try
=sumproduct((daternga2)*(daterng<=a3))
to sum
=sumproduct((daternga2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
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)

count between start date and end date
 

Is there a thinking cap store in your neighborhood?

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

--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
sorry aboutt his again..but what is a2 and a3?

I have start date in column D and end date in column e


"Don Guillett" wrote:

try
=sumproduct((daternga2)*(daterng<=a3))
to sum
=sumproduct((daternga2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
--
Don Guillett
SalesAid Software

"flow23" wrote in message
...
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)