no, i just know who to ask if i have problems.

--


Gary


"Bob Phillips" wrote in message
...
Now you are not saying I am obsessed with SUMPRODUCT are you <bg

Bob


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'll try a bob phillips approach:<g

assuming running dates are in a1:a25, this would sum everything in g within
the date range of a6:a20

=SUMPRODUCT(--(G1:G22),--(A1:A22=A6),--(A1:A22<=A20))

--


Gary


wrote in message
ups.com...
I want to calculate the total of column G from particular date
period.

Anyone has ideas?