Query Formula

  • Thread starter Thread starter DanBanez
  • Start date Start date
D

DanBanez

Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
 
-----Original Message-----
Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
.
Click to expand...
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
 
Can somebody tell me the correct formula to query entries,
let say, payments made between 1 Jan 04 - 31 Jan 04.
Click to expand...

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
 
Back
Top