In your reply, you stated the following: (for adding numbers within the last
6 months in columns C and D:

=SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D)

IT WORKS PERFECTLY.

There are 2 items I do NOT understand.

1) the C:C and D:D references (although I can figure it out) and

2) The use of "&" -- the ambersand.

PLEASE EXPLAIN??

Thank you,

FLKulchar