I'm trying to calculate an average accross multiple worksheets. I could pull all values into the final worksheet, but there must be a way to do this without...

I have a final issue with my measurements sheet. I have several columns designed to calculate how long it has taken people to do something ie, lines minutes...

I have a worksheet (sheet 1) which include the following columns: Audit Date.... Name.... File Score... (A3:A9949) (D3:D9949) (L3:L9949) On the...

Hi This should be simple, but I don't have an answer. How do I calculate the average of a range of values based on a user selection. I have drop down...

I have 4 employees and 54 clients i want to calculated the average client for each employee.

TRYING TO AVERAGE NUMBERS FROM DIFFERENT WORKSHEETS WITHIN SAME WORKBOOK.

I need to calculate the average rate both Year To Date and for the same period last year. I have two rows of data. Row 1 shows Current Year average rates...

I'm trying to calculate the average minutes and seconds for a given task. We have 4 sets of minutes and seconds. I want the minutes and seconds to display...

I want to calculate the average of numbers in one column based on crieteria in another colume. If the value in column A = x, sum and average the corresponding...

calculate average in percentage coloumn with #DIV/!. When the formula has to calculate the average of a few figures it must ignore all error if present in the...

I have a training spreadsheet which includes distance in miles xx.xx (column D) and lapsed time in h:mm:ss (column E) How do you enter and format the lapsed...

Hi, I am tyring to caluculate averages but only in cells above where there is data, i.e. I want it to stop when there is no more data above. Is there an easy...

I have a large array of data which has intermittent zero values in it where the data has not been acquired. I want to create a generic formula which I can copy...

Hi is there a way to figure out a date 9 months previous to a date? eg. I have an install date of 12/02/10, is there a way or a formula that can count back...

Every time ya'll have helped I was working on something for the corporate office, now I've been transferred to the corporate office - not sure if that's good...

I periodically have a situation where I know the ages of a list of people and need to convert the ages into birthdates. i.e. Age 43 - instead of manually...

Hello How do I calculate 4 business weeks from a given date Lets say four business week from Friday March 2 2007 If the due date falls on a saturday...

I need to calculate how many business days between 2 dates. G2 is report submission date H2 is report reviewed date K2 is the result - how many days it took to...

How do I calculate business days without using the analysis...

I need to make a formula that will multiply an amount in a cell by 25% if the date in that row is within 6 months of todays date or multiply by 15% if over 6...