Sum with special requirement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

firroo - 29 May 2008 09:19 GMT

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

Reply to this Message

Bob Phillips - 29 May 2008 09:25 GMT

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

Signature

---
HTH

Bob

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

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

firroo - 29 May 2008 09:48 GMT

Thanks Bob, It was exactly what I wont.

Regards

> =SUM(B11:INDEX(B11:M11,,COUNT(W11:AH11)))
>
[quoted text clipped - 10 lines]
> >
> > Thanks

Reply to this Message