Sum with special requirement

[firroo]

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

 

[Bob Phillips]

=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]

Thanks Bob, It was exactly what I wont.

Regards

=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)