Must be an easy add-in

[Guest]

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???

 

[Peo Sjoblom]

=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

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???

 

[Ron de Bruin]

Hi Poolie'sGal

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