Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 12, 07:52 AM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2012
Posts: 1
Default Sorry if already here. Average HELP!!!

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. So one server might work mon/wed/fri. So i need a formula that averages the amounts only when a value is imputed. But it needs to be already setup so 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?


thanks so much

  #2   Report Post  
Old February 3rd 12, 02:08 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 143
Default Sorry if already here. Average HELP!!!

This is a good question.

Set up a seven day table. Pick any starting day you like. Assign a
row or column for each server. Say Ellen's name is in A1 and the
weekly values are in A2 thru A8. In A9 enter:

=AVERAGE(A2:A8)

It is important, that in A2 thru A8, to leave the value blank rather
than zero for non-working-days. AVERAGE() will ignore blank values.
  #3   Report Post  
Old February 4th 12, 01:37 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 829
Default Sorry if already here. Average HELP!!!

"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

  #4   Report Post  
Old February 4th 12, 04:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 39
Default Sorry if already here. Average HELP!!!

tjcosmo,

Cell:
A1:

Type Employee Name

B1 through H1:

Type Sunday to Saturday

I1:

Type or Copy/Paste the following formula in the cell, then Press Enter

It will give the average based on the days worked.
=IF(COUNT($B2:$H2)=0,0,AVERAGE($B2:$H2))

J1:

If you want to have the daily average in a week even if the person doesn't
work every day. You can Type or Copy/Paste the following formula in the
cell, then Press Enter
=IF(COUNT($B2:$H2)=0,0,SUM($B2:$H2)/7)

You can use an "X" (w/o quotes) for days off, it should not alter the
results.

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"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. So one
server might work mon/wed/fri. So i need a formula that averages the
amounts only when a value is imputed. But it needs to be already setup
so 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?


thanks so much




--
tjcosmo


  #5   Report Post  
Old February 4th 12, 04:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 39
Default Sorry if already here. Average HELP!!!

tjcosmo,
I should have added for Cell "I1" and Cell "J1":

Click and Fill down the column with the formulas for every row of employee
names.


--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"Rich/rerat" wrote in message
...
tjcosmo,

Cell:
A1:

Type Employee Name

B1 through H1:

Type Sunday to Saturday

I1:

Type or Copy/Paste the following formula in the cell, then Press Enter

It will give the average based on the days worked.
=IF(COUNT($B2:$H2)=0,0,AVERAGE($B2:$H2))

J1:

If you want to have the daily average in a week even if the person doesn't
work every day. You can Type or Copy/Paste the following formula in the
cell, then Press Enter
=IF(COUNT($B2:$H2)=0,0,SUM($B2:$H2)/7)

You can use an "X" (w/o quotes) for days off, it should not alter the
results.

--
Rich/rerat
(RRR News) (message rule)
((Previous Text Snipped to Save Bandwidth When Appropriate))


"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. So one
server might work mon/wed/fri. So i need a formula that averages the
amounts only when a value is imputed. But it needs to be already setup
so 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?


thanks so much




--
tjcosmo





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A formula to AVERAGE IF but only average a set number of values [email protected] Excel Worksheet Functions 2 January 31st 08 09:28 PM
Find monthly average but have average automatically configured kimbafred Excel Discussion (Misc queries) 2 August 8th 07 12:28 AM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
Weighed Average of a weiged average when there are blanks krl - ExcelForums.com Excel Discussion (Misc queries) 1 July 6th 05 07:37 PM
how does one convert text to a formula "average(A:A)" to =average( phshirk Excel Worksheet Functions 4 April 14th 05 01:20 AM


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017