If you're using Excel 2007 you can. If you're not using Excel 2007 you can
use entire columns with the SUMIF version but not the SUMPRODUCT version.

--
Biff
Microsoft Excel MVP


"confused in tn" wrote in message
...
Can I use the entire columns instead of a range of cells for the dates and
the payments?

"Ken Johnson" wrote:

On Dec 1, 2:27 pm, confused in tn <confused in
wrote:
I need a formula to total for quarterly date ranges. For example: if
a
payment was received during 4/1/08 - 6/30/08 sum the payments.

One way, assuming payment dates are in A2:A1000 and payment amounts
are in B2:B1000...

=SUMPRODUCT(--($A$2:$A$1000=DATE(2008,4,1)),--($A$2:$A$1000<=DATE
(2008,6,30)),$B$2:$B$1000)

Ken Johnson