=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
"OPB3" wrote in message
...
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 "Buget Average" and an "Actual Average" 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:
http://www.excelforum.com/member.php...o&userid=33686
View this thread: http://www.excelforum.com/showthread...hreadid=534713