average formula

Twice a day I take my BP & heart rate. Each time I take 3 tests and then manually AVG. The format I use in each column for the digital testing machine's results is S/D-H (85/70-81). Because this is a standard way of showing these 3 measurements and because with a total of 6 measurements a day...

So I have two sheets. One sheet has my employee list with historic Start and End Dates. My other sheet is the summary of that list by Month. For example, lets say I have 10 Employees on my Employee sheet that all have Start and End dates, on my second sheet I have to summarize that info by...

Hello, I have cells C5:C36 that contain a series of IF formulas (=IF(B5="L4(+)","95%",IF(B5="L4","85%",IF(B5="L4(-)","80%",IF(B5="L3(+)","79%",IF(B5="L3","75%",IF(B5="L3(-)","70%",IF(B5="L2(+)","69%",IF(B5="L2","65%",IF(B5="L2(-)","60%",))))))))) that reference the adjacent cells B5:B36. When I...

I am looking to create a macro that will prompt the user for a number. This number will represent the number of columns to used to create the average formula. Here is where I am at so far... Sub ave_test() Dim averange As Integer showavebox: averange = InputBox("Enter the number of...

Hi guys, I would like to calculate the average power over a specified time range. I could use the average function. However, the time increments are not consistent. As you can see in the table, the time increments vary. I think that the average function would assume that each time row is...

Hi there, I am new to this forum (1st Post) and also new to excel. I am currently doing my bookkeeping course and i am stuck on a question and need some help. The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to...

Hi , i have some data that i am trying to extend i have got to the stage where i can insert a new row between all of my data sets i would now like to be able to fill in the average between the above and below cell. So in the example below i have time and distance . In both columns i like...

I'm in great need of formula to save me an extreme amount of time and angst. I am attempting to average blood vessel dilation every 20 seconds. I have seconds recorded in one column and diameter in another column. The issue I'm having is that time is not recorded consistently. <tbody> Time...

Hi, I have a worksheet with 35,136 rows of data. I want to calculate the average of every 4th cell in the same column. Is there a way to create a macro to select every 4th cell in the average formula? If so, can I then substitute min and max for average? Thanks.

I am trying to figure out a formula that calculates for the average number of studies ordered by a doc, per patient encounter on a given date. 'Per Patient Encounter' is defined as each specific date that the DOC saw the PATIENT which counts as (1) encounter. Here is an example of my pseudo...

Hi Everyone, I'm trying to come up with a simple macro that will scan through a list and calculate the average for a range that has a specific variable. So it would go through the following table and give me the average for all the red's and then the average for the blue, and then the green...

Hi all, I have looked here a lot in the past for help but this is the first time I have had to post a problem as I just can't figure out how indirect functions work. I have a workbook with two sheets, one with raw data (named RAW) and one in which I would like to have average values etc...

I'm trying to figure out how to proceed in calculating an average with following conditions: In column B, I'm looking for the average of variable length, defined by a Time value (e.g. 5 from cell 'Time') meaning this would be the average of the 5 first numbers from column A. The average...

Hi I'm in the process of building a sheet for the guys at work. Part of the sheet requires me to take a range of cells, convert them using hlookup into either straight values or text and then average the resulting range. Doing this as a two step process fine, but nesting the text returns from...

I have a document with 41 sheets, 39 of which are basically the same. On sheet 40 I have a summary of the first 39. This is a small portion of page 41. They go all the way across to Week 39 in two seperate tiers. <TABLE style="WIDTH: 229pt; BORDER-COLLAPSE: collapse" border=0...

I am working on a project that involves trackable keypunching for a designated time frame. I need a formula that will give me the average time spent on a certain task. Here's what I have: 1. Number of "batches" completed 2. Number of pages within a single batch 3. Time spent on each batch...

Hi I am new to the power of Excel and am in need of some help! I have searched and read a number of similar problems but nothing quite matches or has worked for me, so I'm sorry if this a repetitive question! I will set the scene. I have a sheet for each week of the year and each sheet has...

Hi after realizing that I needed a macro and after realizing that it was just a bit messy for me I asking for help. I have several folders. In each folder I have about 25 spreadsheets with numerical data (nothing fancy). In each sheet there are many more columns and they vary with size. what...

I thnk this should be easy but I did not find it in a quick look through the archives. I have an example where I want to find the state average (mean) but the way the state reports the data makes it more complicated. It does not tell me the state average but it does tell me the number of kids...

I have numbers in 7 columns looking like this: <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448><COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid...