 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005adding and divideing by a the number of cells!
Hey guys im making an excell document, i want to make a function tha does this : adds all the filled out cells(not the empty ones) and divides them b their number (again ignoring the empty ones) so that if i have a ro A1-10 it counts all the cells filled out and divides them by thei number im not good at english but i know there is a word for tha m-something... so could you guys *Fully* explain? You see if th teacher asks me how i did itt i have to explain and understand thanx! zA =AVERAGE(A1:A10) =SUM(A1:A10)/COUNT(A1:A10)  SignatureRegards, Peo Sjoblom > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk =AVERAGE(A1:A10) SignatureHTH Bob Phillips (remove nothere from email address if mailing direct) > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk Zak, Sounds like you just need a simple average of cells containing values. Use, =AVERAGE(A1:A10) The function will ignore blank cells. AVERAGE adds up the values i the list and then divides that sum by the number of non-blank cells. Cheers, Stev I think the AVERAGE function will satisfy your request: B1: =AVERAGE(A1:A10) Does that help? *********** Regards, Ron > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk How about =AVERAGE(A1:A10)? Signaturetj > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk Since you are supposed to be learning something, go read about the SUM() and COUNTIF() functions. With that headstart and a little thinking on your part, you should get a top grade! > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk Hi If I understand correctly, you are trying to calculate the 'average' of a selection of figures? This will add all the figures together and then divide the answer by the number of figures you have. If this is what you want:- 1. Go to the cell you want the answer in. 2. Click onto the drop down arrow beside AutoSum and choose Average. 3. Highlight the cells you wish to calculate. 4. Press Enter. It will give you a calculation of =Average(A1:A10) HTH Louise > Hey guys im making an excell document, i want to make a function that > does this : [quoted text clipped - 6 lines] > > zAk |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.