D
DanBanez
Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
let say, payments made between 1 Jan 04 - 31 Jan 04.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Use "Between #1/1/2004# And #12/31/2004#" for the
criteria in the query.
criteria in the query.
P
Peter atherton
Dan-----Original Message-----
Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
.
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
F
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