YTD Budget Totals

Hi -
I need to get budgeted year-to-date totals for a budget worksheet. Range
E7:P7 has actuals for the months (Jan-Mar) YTD. Range E8:P8 has the budgeted
amounts by the months (Jan-Dec) for 2005. I need to show budgeted amounts in
Q8 only for the months in which there are acutual numbers which will give me
an actual vs. budget ytd. I would like to implement a formula so I do not
have to expand the column range 1 month manually each month.
Any help is appreciated.
Thank you
--
Dewayne

Hi!

Try this in Q8:

=SUMPRODUCT(--(ISNUMBER(E7:P7)),E8:P8)

Biff

>-----Original Message-----
>Hi -
>I need to get budgeted year-to-date totals for a budget
worksheet. Range
>E7:P7 has actuals for the months (Jan-Mar) YTD. Range
E8:P8 has the budgeted
>amounts by the months (Jan-Dec) for 2005. I need to show
budgeted amounts in
>Q8 only for the months in which there are acutual numbers
which will give me
>an actual vs. budget ytd. I would like to implement a
formula so I do not
>have to expand the column range 1 month manually each
month.
>Any help is appreciated.
>Thank you
>--
>Dewayne
>.
>

Thank you for the help Biff

"Biff" wrote:

> Hi!
>
> Try this in Q8:
>
> =SUMPRODUCT(--(ISNUMBER(E7:P7)),E8:P8)
>
> Biff
>
> >-----Original Message-----
> >Hi -
> >I need to get budgeted year-to-date totals for a budget
> worksheet. Range
> >E7:P7 has actuals for the months (Jan-Mar) YTD. Range
> E8:P8 has the budgeted
> >amounts by the months (Jan-Dec) for 2005. I need to show
> budgeted amounts in
> >Q8 only for the months in which there are acutual numbers
> which will give me
> >an actual vs. budget ytd. I would like to implement a
> formula so I do not
> >have to expand the column range 1 month manually each
> month.
> >Any help is appreciated.
> >Thank you
> >--
> >Dewayne
> >.
> >
>

You're welcome! Thanks for the feedback.

Biff

>-----Original Message-----
>Thank you for the help Biff
>
>"Biff" wrote:
>
>> Hi!
>>
>> Try this in Q8:
>>
>> =SUMPRODUCT(--(ISNUMBER(E7:P7)),E8:P8)
>>
>> Biff
>>
>> >-----Original Message-----
>> >Hi -
>> >I need to get budgeted year-to-date totals for a
budget
>> worksheet. Range
>> >E7:P7 has actuals for the months (Jan-Mar) YTD. Range
>> E8:P8 has the budgeted
>> >amounts by the months (Jan-Dec) for 2005. I need to
show
>> budgeted amounts in
>> >Q8 only for the months in which there are acutual
numbers
>> which will give me
>> >an actual vs. budget ytd. I would like to implement a
>> formula so I do not
>> >have to expand the column range 1 month manually each
>> month.
>> >Any help is appreciated.
>> >Thank you
>> >--
>> >Dewayne
>> >.
>> >
>>
>.
>