=SUM(B11:INDEX(B11:M11,,COUNT(W11:AH11)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"firroo" wrote in message
...
Hi all,

I have the budget split on monthly basis & I want a formula that when I
update the sales it will calculate to me the budget till that month.

Example if the Cells w11 to z11 contain the sales figures from Jan to
April,
the formula should sum the budget from Jan to April b11:e11.

Thanks

Thanks