I have a worksheet that has multiple columns including a begin date, end
date, and a value. What I need to do is get daily totals for the all the
dates in the 4th quarter (from 10/1-12/31). The worksheet has over 100
records in it so to put an SUMIF formula in would be lengthy. Any ideas???

=SUMPRODUCT(--(A1:A100=DATE(2004,10,1)),--(B1:B100<=DATE(2004,12,31)),C1:C1
00)

where A holds start date and B end date, amounts in C


Regards,

Peo Sjoblom

"Poolie'sGal" wrote in message
...
I have a worksheet that has multiple columns including a begin date, end
date, and a value. What I need to do is get daily totals for the all the
dates in the 4th quarter (from 10/1-12/31). The worksheet has over 100
records in it so to put an SUMIF formula in would be lengthy. Any
ideas???

Hi Poolie'sGal

If you want a easy Add-in for the quarter then try
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Poolie'sGal" wrote in message ...
I have a worksheet that has multiple columns including a begin date, end
date, and a value. What I need to do is get daily totals for the all the
dates in the 4th quarter (from 10/1-12/31). The worksheet has over 100
records in it so to put an SUMIF formula in would be lengthy. Any ideas???