Adding in a Date Range
Thanks...worked great!!!
"Mike H" wrote:
Hi,
When summing in this way it's a good idea to keep the date to sum outside of
the formula so with 1/2/2008 in C1 the day of the monthe can be any
=SUMPRODUCT(--(YEAR(A1:A20)=YEAR(C1)),--(MONTH(A1:A20)=MONTH(C1)),B1:B20)
This will add up coolumn B for every Feb 2008 in column A1 - A20
Mike
"readystate" wrote:
I have a worksheet with a Date Column. I want to include a formula that will
add, for example, amounts for the month of February 2008. How would I set
that up? Thanks in advance.
|