thanks

I finally figure it out
For Jan I use
=SUMIF(CBN!$A:$A,"=" & DATE(2004,1,1),CBN!$F:$F)-SUMIF(CBN!$A:$A,"=" &
DATE(2004,1,31),CBN!$F:$F)
For Feb I use
=SUMIF(CBN!$A:$A,"=" & DATE(2004,2,1),CBN!$F:$F)-SUMIF(CBN!$A:$A,"=" &
DATE(2004,2,31),CBN!$F:$F)

"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?