how do I aggregate dates
That worked. Thank you so much. Your quick response was great.
"Toppers" wrote:
Try:
=SUMPRODUCT(--(MONTH(G3:G73)=Month(G3)),--(H3:H73))
"Johnopp" wrote:
Here is what I have:=SUMPRODUCT((MONTH(G3:G73)=G3),(H3:H73))
I have dates in column G and the product amounts in column H. I am getting
a zero with no message. The date format in G3 is month/year under
"datevalue" as I had to convert a text date. Do I need to have a month
number only or a month? I got the file from Microsoft CRM.
"Toppers" wrote:
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.
|