Thread
:
Moving range?
View Single Post
#
2
December 23rd, 2009, 09:16 PM posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 6,167
Moving range?
Not much detail but something like for dates in col A 3=march
=sumproduct((month(a2:a22)=3)*(month(a2:a22)=10)*b 2:b22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"wx4usa" wrote in message
...
I have Months in B1:M1.
Dollars in B2:M2
I need a formula to return the sum dollars of a range of consecutive
months that is variable such as.....start month is in cell a1 and end
month is in a2. a1=March a2=October
Thank you so much for your help!!
Don Guillett
View Public Profile
View message headers
Find all posts by Don Guillett
Find all threads started by Don Guillett