Query Formula

[DanBanez]

Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.

 

[Guest]

Use "Between #1/1/2004# And #12/31/2004#" for the
criteria in the query.

 

[Peter atherton]

-----Original Message-----
Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
.

Dan

Assuming dates are in A4 to A13 and Payments in B4:b13

=SUMIF(A4:A13,">=1/2/04",B4:B13)-SUMIF
(A4:A13,">5/2/04",B4:B13)

gets the sum for 1st to the 5th of Feb

Regards
Peter

 

[Frank Kabel]

Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.

Hi
one way (assumption your payments are in column A):
=SUMPRODUCT((A1:A1000>=DATE(2004,1,1))*(A1:A1000<=DATE(2004,1,31))
to just count the payment occurences in January
=SUMPRODUCT((A1:A1000>=DATE(2004,1,1))*(A1:A1000<=DATE(2004,1,31),A1:A1
000)
to sum the payments in January

Frank