no go
This is my data value
DATE LC NO LC AMOUNT
01-01-04 USD1,000.00
15-01-04 USD1,000.00
02-02-04 USD1,000.00
Try to create another sheet as follows;
CUSTOMER JAN FEB MAR
C.B.N. ONE OF THE BOYS 2,000.00 1,000.00
This is how is looks at the moment :-(
CUSTOMER JAN FEB MAR
C.B.N. ONE OF THE BOYS 3,000.00
Is this possible
"Frank Kabel" wrote in message
...
Hi
try:
=SUMIF(A1:A100,"=" & DATE(2004,1,1))-SUMIF(A1:A100,"=" & DATE(2004,2,1))
"D@annyBoy" wrote:
thanks it works
but can I use a range of dates instead
sum all cells if month is Jan
will this work =SUMIF(A1:A100,"=" & DATE(1,1,2004),"<="&
DATE1,2,2004,B1:B100)
"Frank Kabel" wrote in message
...
Hi
for example
=SUMIF(A1:A100,"=" & DATE(2004,10,1),B1:B100)
"Lius" wrote:
How do I add up a range of cells using dates as a criteria?
|