averages

hi, I don't know how to explain, but I'll try :) I have 5 worksheets (each of them being 8 columns x 52 rows... if this matters) with the first worksheet aggregating (totaling, averaging, etc.) data from the other 4. Now, the secondary worksheets are fine and I can fiddle with them as I wish...

I have Spring and Fall scores being displayed as averages in my pivot table. I'd like to add a calculated field (to my pivottable) that subtracts the spring and fall averages. However, it will only subtract the SUM of the spring and fall scores. Does anyone know how to subtract values...

I need to figure out how to get the averages of the highlighted cells for each product number in a couple steps because I have over 4,000 rows to do this with... thanks

Can anyone please help me with an array. I am trying to find a particular position containing a value e.g. 10, 20, 40 etc...then take the 5 values above and 5 values below including the value I am searching for and do an average of it, thus doing an average of 11 values. So far I have managed to...

Hello, I am stumped on an issue....I have a large database (>10^6 rows). I need help to find a formula that will average the MGD values (see below) by month. The data has a date range from about 02/01/2010-02/01/2013. Another issue that I have to deal with is the "Facility Name" column. There...

Hey guys, Just looking for a quick bit of help. Looking to use averageif for two conditions. Normally I'd use the averageifs formula, but, it's not two conditions on one value it's one value where it can be A or B. I've even tried the OR function with no success... So, what I've tried to do...

I have two cells that give me a percentage. One is a cell that is the average add on sales percentage for the month and changes every day as new info is entered. On each day of the month I have one cell that reflects the current percentage calculated on another sheet and the other is the...

This is my first time posting here and am very new to excel, but feel as for the most part have a good grasp on the basics that I need for work. I am creating a monthly ledger for my restaurant. What I am needing is this. I am taking my total sales against my COG's for a total percentage of...

Hello all! So I am trying to rank a column of numerical data by a given average of the cells: Assume, Column "D" is: <table width="86" border="0" cellpadding="0" cellspacing="0"><col style="width: 65pt;" width="86"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22"...

Hi I have 3 columns showing sales for the the last 3 years. How can i create a 4th column to show the average of the 3 years. can you please explain the process and i can then apply the same for quantities etc. I am using Excel 2010 all help sincerely appreciated regards

I have a sheet that contains data that repeats. For example, e10 to e27 contains a mail quantity, revenue, credit payments, etc. These same 18 sets of data are duplicated down the sheet for different groups. I need to find the average of the following: e26,e45,e64,e83,e102,e121,e140,e159...

Hi, I did originally post this question on the thread "Averages in Pivot Tables", but as that thread was last used in 2006, it seems my query may have been missed, so I am starting a new thread...just wanted to pre-empt a telling off from the moderators! I am working with a database which uses...

Hi - Firstly, I want to say a big thanks to anyone that can help with the following and please bear with me while I explain. I have a scale of data - lets say the following: A B C D E 1 1 1 1 1 where the 1's can be replaced by any figure by the person completing the survey. In the following...

Hello All, This is my first post, so any answers would be greatly appreciated. I need to know if there is a way to remove the zeros from my averages inside a pivot table. Ex: I have 10 people on a team, but only 5 have data, the other 5 have zeros. I want have the average in the pivot table to...

I am trying to come up with a spreadsheet that has 1 page of sales from 6/18/07-8/16/07 (43 days), with 3 rows beneath each column: Row 45=Total (=Sum(b2:b44)), Row 46=Average (=Average(b2:b44)), and Row 47=Average + 10% (=Sum(b46+(b46*.1))). The next page has a daily input from 6/16/08-8/15/08...