"tjcosmo" wrote:
in message ...

So I'm a restaurant manager and we track our server PPA's. which is a
fancy thing for server check amounts. I want to track each server each
week. Here's the thing, each server does not work everyday.
[....]
when i put in the days averages it recomputes it again. and if a
server works another day like sat it would then average 4 days instead
of 3. Is ther anyway to do this?

There might be nothing special for you to do. The AVERAGE function
automatically ignores empty cells and cells that contain text such as the
null string (""). So if you use columns B through H to track a week,
=AVERAGE(B2:H2) might do what you want.

If not, you need to specify more details. Better still, upload an example
Excel file to a file-sharing website, be sure the uploaded file is marked
shared/sharable, then post the URL (aka link; http://...) of the uploaded
file here. The following is a list of some free file-sharing websites; or
use your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
FileDropper: http://www.filedropper.com
RapidSha http://www.rapidshare.com