Sum with special requirement
 

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

Sum with special requirement
 

=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

Sum with special requirement
 

Thanks Bob, It was exactly what I wont.

Regards

"Bob Phillips" wrote:

=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