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!!