how do I aggregate dates
Assumes dates in column A and Sales in B then following will give total for
March.
Change 3 to a cell if you the month value stored in a cell
=SUMPRODUCT(--(MONTH($A$2:$A$100)=3),--($B$2:$B$100))
C2=3
=SUMPRODUCT(--(MONTH($A$2:$A$100)=C2),--($B$2:$B$100))
HTH
"Johnopp" wrote:
Did anyone figure out how to do this? There is a posting from CommuterVet
that ends with a problem that countif only took the last one.
I have a sales forecast that is by day,month,year, and I want to subtotal by
month or put it into a pivot table and have it aggregate by month, but I
can't seem to be able to do it.
|