software

I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
Actual(V5) columns. This is repeated 12 times across the sheet. I then
have quot;Buget Averagequot; and an quot;Actual Averagequot; cell. The budget average
is easy because all cells have values for all 12 months. How do I
average the actual since only a few months have data?

This shoud be simple but I have read 200 posts and have not found
anything. All suggestions were for ranges/adjacent cells.--
OPB3
------------------------------------------------------------------------
OPB3's Profile: www.excelforum.com/member.php...oamp;userid=33686
View this thread: www.excelforum.com/showthread...hreadid=534713=AVERAGE(B1:M1)

Will average that range ignoring blank cells. If B, C, D, E are 1 2 3 4,
returns 2.5

=AVERAGE(Data)

If the cells are not all together, where Data is a named range, does the
same.

HTH
Regards,
Howard

quot;OPB3quot; gt; wrote in message
...
gt;
gt; I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
gt; Actual(V5) columns. This is repeated 12 times across the sheet. I then
gt; have quot;Buget Averagequot; and an quot;Actual Averagequot; cell. The budget average
gt; is easy because all cells have values for all 12 months. How do I
gt; average the actual since only a few months have data?
gt;
gt; This shoud be simple but I have read 200 posts and have not found
gt; anything. All suggestions were for ranges/adjacent cells.
gt;
gt;
gt; --
gt; OPB3
gt; ------------------------------------------------------------------------
gt; OPB3's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33686
gt; View this thread: www.excelforum.com/showthread...hreadid=534713
gt;
This worked for me where F1 is a link to another sheet cell A1 and holds a
lookup value for my table array on sheet 1.

=VLOOKUP(INDIRECT(F1),A1:B3,2,0)

The comment and color is a no, as far as I know.

HTH
Regards,
Howard

quot;OPB3quot; gt; wrote in message
...
gt;
gt; I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
gt; Actual(V5) columns. This is repeated 12 times across the sheet. I then
gt; have quot;Buget Averagequot; and an quot;Actual Averagequot; cell. The budget average
gt; is easy because all cells have values for all 12 months. How do I
gt; average the actual since only a few months have data?
gt;
gt; This shoud be simple but I have read 200 posts and have not found
gt; anything. All suggestions were for ranges/adjacent cells.
gt;
gt;
gt; --
gt; OPB3
gt; ------------------------------------------------------------------------
gt; OPB3's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33686
gt; View this thread: www.excelforum.com/showthread...hreadid=534713
gt;
Hmmmm, I do believe I got my threads mixed up!

Sorry

Howard

quot;OPB3quot; gt; wrote in message
...
gt;
gt; I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
gt; Actual(V5) columns. This is repeated 12 times across the sheet. I then
gt; have quot;Buget Averagequot; and an quot;Actual Averagequot; cell. The budget average
gt; is easy because all cells have values for all 12 months. How do I
gt; average the actual since only a few months have data?
gt;
gt; This shoud be simple but I have read 200 posts and have not found
gt; anything. All suggestions were for ranges/adjacent cells.
gt;
gt;
gt; --
gt; OPB3
gt; ------------------------------------------------------------------------
gt; OPB3's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33686
gt; View this thread: www.excelforum.com/showthread...hreadid=534713
gt;
=AVERAGE(B1:M1)

Will average that range ignoring blank cells. If B, C, D, E are 1 2 3 4,
returns 2.5

=AVERAGE(Data)

If the cells are not all together, where Data is a named range, does the
same.

HTH
Regards,
Howard

quot;OPB3quot; gt; wrote in message
...
gt;
gt; I have Budget SpreadSheet thet is set by month(U3), then Budget(U4),
gt; Actual(V5) columns. This is repeated 12 times across the sheet. I then
gt; have quot;Buget Averagequot; and an quot;Actual Averagequot; cell. The budget average
gt; is easy because all cells have values for all 12 months. How do I
gt; average the actual since only a few months have data?
gt;
gt; This shoud be simple but I have read 200 posts and have not found
gt; anything. All suggestions were for ranges/adjacent cells.
gt;
gt;
gt; --
gt; OPB3
gt; ------------------------------------------------------------------------
gt; OPB3's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33686
gt; View this thread: www.excelforum.com/showthread...hreadid=534713
gt;