Over 1 million tech questions and answers.

Solved: Calculate an average

Q: Solved: Calculate an average

In excel I would like to calculate the value of Column A ($) / Column B(# of years) across the row, one result per column for each number of years.

Any suggestions would be greatly appreciated

Example:
7 $2,800 $400 $400 $400 $400 $400 $400 $400
5 $364 $73 $73 $73 $73 $73
3 $150 $50 $50 $50
2 $200 $100 $100
3 $250 $83 $83 $83
2 $210 $105 $105
2 $210 $105 $105
2 $200 $100 $100
2 $100 $50 $50
1 $140 $140

RELEVANCY SCORE 200
Preferred Solution: Solved: Calculate an average

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Calculate an average

The ideal way would probably be to use macros. However if you put this in every box that may hold the results (i.e. every box with a 400 in your first example, for the maximum number of columns you'll have years) it should work
Code:
=IF(COLUMN()-2<=A1,B1/A1,"")

Read other 2 answers
RELEVANCY SCORE 81.6

Dear all,

I hope someone could help me with this request:

I have to find a formula that calculate the "Average six weeks'cash trading (turnover) over the last 6 months"

More details are shown on the attached Excel file

Thank you a lot!

 

A:Solved: Calculate the "Average six weeks'cash trading (turnover) over the last 6 mont

you have monthly figures showing - not sure i understand what you need to do

where are the weekly figures ?
 

Read other 3 answers
RELEVANCY SCORE 50.8

Hi,

I need a function, which will get Date of Birth and Result the Age.
Can some one help me.

Thanks,

Riyas
 

A:Solved: Calculate Age in VB6

Sorry guys, I got it already after searching the forum.
 

Read other 1 answers
RELEVANCY SCORE 50.4

I have a Inspirion 15 5558,with i7, 8GB ram,1TB HDD,My average To reach the login screen was around 45 secs.
I was facing LCD issues, the technician came over and checked the LCD and pasted some stickers on i it so that it can be repaired later.
I found that its taking more than 4 minutes to reach the login screen.
When i contacted the technician he said it was an OS problem and that i should downgrade to 8 or 8.1
so if everyone can comment about their boot time it would be helpful in determining the problem.

Thank you 

A:What is the average boot time/average time to reach the login screen of Inspirion 15 5558 Win 10?

" I found that its taking more than 4 minutes to reach the login screen ".

I like to suggest you launch "Startup Repair" in Advanced Startup:
A) Type settings in the (Cortana) search bar, Update & Security, and then Recovery
B) Click Advanced Startup, and then " Restart Now "
C) Troubleshoot, Advanced Options, and then Startup Repairs

I also like to suggest you check Startup in Task Manager.Please disable some of the programs that you don't want running in your startup.
A) Type Task Manager
B) Click Startup

Read other 3 answers
RELEVANCY SCORE 50

I wish to formulate stepwise formula for calculating Income tax.

"if taxable income is between 100000 to 150000, then it attracts 10% of the amount excess of 100000." [Other wise NO tax]
"if between 150000 to 250000, then 20% of amount excess of 150000 Plus 5000 of the previous step."
"if above 250000, then 30% of amount excess of 250000 Plus 20000 AND 5000 of previous STEPS."
How can I place maximum figure of slabs in each step, when I have income of ,say, 260000.
I wish to put it step wise, so that 5000 for first slab, then 20000 for next slab and rest in third slab. At the end, The total will be placed.
Please see my attached txt file after " unwrapping" text in Format of Notepad.
thanks.
 

A:Solved: help me calculate Income tax.

Read other 9 answers
RELEVANCY SCORE 50

Have read this link http://excelsemipro.com/2010/12/calculate-the-xth-weekday-of-any-month-in-excel/
and downloaded their spreadsheet, called
Xth weekday of a monthClick to expand...

Have unsuccessfully tried to replicate it in a spreadsheet I called
Calculate 4th Tuesday of each monthClick to expand...

Both these files are attached.

Can someone point out where I am going wrong.
Thanks
Pedro
 

A:Solved: Calculate xth day of month

Read other 7 answers
RELEVANCY SCORE 50

Can anyone help me?

I need a way to determine the difference in time between two dates excluding weekends.

For example:

A1: 9/12/2014 8:51
A2: 9/16/2014 14:45

A1 is the start date, A2 is the end date.

The difference between these is 4.25 days, but since it includes a weekend (ideally I'd also include holidays if possible) the ultimate answer I'm looking for is 2.25.

I thought about calculating the total number of week days using NETWORKDAYS, but the problem I run into is that excel includes the entire day even if it's just one hour of that day.

This formula doesn't work because it includes all of 9/12/14 and all of 9/16/14 when I only need it to count a part of those days.

=(A2-A1)-(INT(A2-A1)-NETWORKDAYS(A1,A2))

What would really be great is a NETNONWORKDAYS function (that would calculate weekends and holidays)

Any ideas for me?

Thanks in advance!
 

A:Solved: Calculate Weekends

you can try this
=NETWORKDAYS(A1,A2)-MOD(A1,1)-(1-MOD(A2,1))
 

Read other 2 answers
RELEVANCY SCORE 49.6

Hi,

I am trying to create an excel spreadsheet that will show me the amount of UK Income tax I need to pay when I enter my earnings. I'm sure this must be something that someone else has already achieved.

This is the formula that I have at the moment and that is currently not working:

=IF(B16>150001,((B16-150001)*0.45)+((150000-32012)*0.4)+((32011-9441)*0.2)),IF(150000>B16>32012,((B16-32012)*0.4)+((32011-9441)*0.2)),IF(32011>B16>9441,(((B16-9441)*0.2),"Null"))

It currently gives me a error. The tax brackets are as follows; <9440 @ 0%, 9441-32000 @ 20%, 32001-150000 @ 40%, 150001+ @ 50%. Can anyone see where I am going wrong or have another idea of how I could do this?

Thanks a lot in advance!!

Regards,
Richard
 

A:Solved: Error when trying to calculate UK Income tax

does this work for you

=IF(B16>150001,((B16-150001)*0.45)+((150000-32012)*0.4)+((32011-9441)*0.2),IF(B16>32012,((B16-32012)*0.4)+((32011-9441)*0.2),IF(B16>9441,((B16-9441)*0.2),"Null")))

you had some brackets closing

Also if the first test is false - then the value must be less than 150000 - so you only need to test if greater than the next threshold - 32001
etc

if you want to use between ranges
try
AND( B16<150000, B16>32012)
 

Read other 3 answers
RELEVANCY SCORE 49.6

Hi,

I have a sheet in excel 2003, that has a table that gets its data from different files, and does calculations on it. The size (= amount of rows) of this table varies, so I use the code described here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=512 to remove empty rows (the table is printed after the calculations are done, and having a half empty page before the rest of the text continues does not look nice, so leaving the rows empty is not realy an option). The problem is that the combination of the calculations and the VBA script to remove rows, is slowing my PC down considerably, since with each row that is removed, all calculations are repeated. Is there a way to force excell to only do the calculations the first time around? 1 round of calculations takes about 30 seconds, and it is usually repeated about 20 times (the amount of empty rows that is left after the calculations, which means that my computer is calculating for about 10 minutes, while this is completely unnessecary for my purposes.

Thanks in advance,
Saraal
 

A:Solved: Let excel calculate cells only once

Application.Calculation = xlCalculationAutomatic 'it will change calculation to automatic
Application.Calculation = xlCalculationManual 'it will change calculation to manual
so you could add these to the VBA code to Turn to manual before you delete the rows and then turn back on to automatic at the end
 

Read other 3 answers
RELEVANCY SCORE 49.6

How do I make LibreOffice automatically calulate a row of numbers? I'm used to using Excel, know how to do it there but new computer came with LibreOffice. Many thanks for any input.
 

Read other answers
RELEVANCY SCORE 49.6

How do I calculate age from a date of birth in excel? The output must be in the form of a whole number from which I can calculate mean age etc..
 

A:(solved) Excel: How to Calculate Age w/No Decimals

Read other 11 answers
RELEVANCY SCORE 49.6

I am trying to come up with an Excel spreadsheet that calculates time worked.

For example, 8:00 AM to 12:30 PM would display 2.50 hrs.

Can anyone help me to create a formula that will calculate time?
 

A:Solved: Excel Calculate Time

you marked it solved? But don't you mean 4.5 hours?

if A1 = 8:00 AM and B1 = 12:30 PM

use.. =(B1-A1)*24
 

Read other 2 answers
RELEVANCY SCORE 48.8

Hi,

I wanted to backup my Windows 7 laptop to my Windows 7 desktop however I want to be able to calculate the size of the backup.

Any idea how I can do so?

Thanks!

A:[SOLVED] Calculate Windows Backup Size

Do you want a disk image or personal profile file backup?

Treesize Free for the latter - http://www.jam-software.com/treesize_free/

For the former, use - http://windows.microsoft.com/en-us/w...ings-and-files

I would suggest that you delete pagefile.sys + hiberfil.sys to save space. The will be re-created upon boot-up if/when you restore from the image.

Page file = installed physical RAM + a few hundred MB (on average)
Hibernation file = 75% installed physical RAM

They both are located in c:\ root dir

Kind Regards. . .

John

`

Read other 19 answers
RELEVANCY SCORE 48.8

I am using an Excel spreadsheet to keep a simple record of my bank account - i.e debit, credit and balance in three separate columns. Within the same spreadsheet I am using an 'if, then, else' condition comparing two numbers to determine certain information I want to appear in other cells using the 'balance' figure as part of this condition. For most part this works fine but occasionally it doesn't and when I look closely into the cells that determine the condition I want to meet I find that the cell in the 'balance' column is not calculating exactly.

I have all my cells formatted to two decimal places (e,g. 735.25) however, if I reformat them to multiple decimal places it might display this figure as 735.2499999900. This is causing a problem when I have another input figure elsewhere on the sheet of 735.25 and wish to compare these two figures in my 'if, then, else' condition as they are comparing two different figures, which in effect should be the same, thereby not giving me the anticipated result.

Apart from the figures in the 'balance' column - which are calculated figures using the previous row's balance plus or minus either the inputted credit/debit figure from the current row input to two decimal places - I can see no reason why suddenly my spreadsheet calculates to a figure such as 735.2499999900 when I have only input numbers of two decimal places in the 'debit' and 'credit' columns.
... Read more

A:Solved: Excel appears to calculate incorrectly.

Read other 6 answers
RELEVANCY SCORE 48.8

I would like to calculate a date in Microsoft word in version 2003. I want to us the current days date in a document and add 45 days to this date.

Is anyone able to assist me with this?

Thanks.
 

A:Solved: Calculate a date in Microsoft Word

Read other 9 answers
RELEVANCY SCORE 48.8

Hi,
I'm trying to use Excel to calculate year-end bonuses. Employees can receive a bonus if we hit our targets for the year. Let's say we want to pay a bonus on income. If we hit our income targets, the employee can receive 100% of their target bonus (will vary by employee). However the scale is non-linear. If we miss our targets, the pay scale falls off rapidly. For example, hitting only 85% of are target may pay only 25% of the target bonus and below 85% we pay nothing. At 110% of income, employees may receive 105% of their bonus.

When I plotted the payout, I had to use a scatter graph. You end up with a number of dots connected by lines but each line has a different slope.

Any ideas?
 

A:Solved: Excel to calculate non-linear bonus

Read other 9 answers
RELEVANCY SCORE 48.8

Here is what I am trying to do.
I need to calculate a commission based upon the following scenario.
(5% of the first $100,000 and 3% on the remaining balance.)
I need to create this formula so it can be used on numbers up to 7 digits and be able to adjust the percent amounts up to 2 digits.

Any takers??

Thanks in advance,

Brad
 

A:Solved: Excel formula to calculate commission

Read other 11 answers
RELEVANCY SCORE 48.8

Help,

I've seen several examples of Compare & Calculate, however I have a twist that has stumped me. I have two separate files based on an "as of data date" that I want to compare and then calculate the delta between two numbers and leave the result in the current working file.

The twist is that the current years working file may not have all the rows that are in the previous years file and may also have new ones. The rows represent accounts. An account that is paid to zero during the current year will not be in the current years report. A new account will appear in the the current years file, but not the previous years file.

I need a result that shows the change in the account balance even if the current year doesn't have a row representing an account paid to zero. So the result shows all of the accounts that appear in both reports as though both reports had been consolidated and then shows the change in value of the account balance, either positive or negative, as compared to the previous year.

I've attached a file that uses worksheets (named 2010, 2011 and Delta) as an example. Note accounts #2, #4 and #5 paid to zero and do not appear in "2011", yet appear in "Delta" with a negative number representing the reduction in balance between "2010" and "2011".

Thanks for any help you may be able to provide . . .
 

A:Solved: Excel 2007 - Compare / Calculate

Read other 16 answers
RELEVANCY SCORE 48.8

I have a spread sheet with about 300 rows of data with 3 colums each. the the colums representing different years. at the bottom of each colum i have a =sum( to cacluate the total dollar value for that colum for the 300 rows of data. I would like to have a percentage calculation in the second colum of the dollar amounts as it relates to the total at the bottom of the page. is there a short cut I can use or do I have to manually type the formula in each cell to get the percentage? I'm using office 2007

A (dollar amounts) B (percentage)
1 100 ?
2 100 ?
3 100 ?

total =sum(A1:A3)
 

A:Solved: quick answer calculate percentage

Use the dollar symbol to always refer to the same cell

=A2/$A$4

if you then copy it down it would automatically update A2/A3 and always refer to A4
 

Read other 1 answers
RELEVANCY SCORE 48.4

I can come up with most of the stangest ideas:
I have designed a numer of reports and call these from one lets call it master sheet.
The master sheet has number of objects with associated macro's.
I have forzen the titles in this case in Range("J23")
What I would like to know is how j23 would relate to the active screen resolution.
I found the differente posted codes to calc the screens width and height and based upon that I soom this sheet to the max possible , but do this by trial and error, my screen res is 1280 x 1024 an so I set ActiveWindowzoom = 200 when workbook is activated

Since it's possible that more reports will be added this page will vary so what I want is if the next cell is K36 I would like to know what value this could be in ref to the screenres and then set it to another value, that would then maybe become 175 for my resolution.

I don't know if my explanation / question is clear but .... with all the knowledge in the Forum I'm sure somebody has a solution for me.

Thanks
 

A:Solved: EXCEL VBA: calculate cell position on screen

I think I found it, am testing.
What I did:
The column width is default 8.43 characters so this is 8.43 x 8 = 67.44 pixels found the poarameters with Google
1 character (X) = 8 pixel (X)
1 character (Y) = 16 pixel (Y)

with a for 1 to 10 (column J=10) I add the columnwidths por these 10 columns * 8 gives me the pixels
screenresolution width vs the pixels gives a zoom value

BTW the same agoes for the rows, The pixel value is 16 for a row so you can calculate the columns 1 - 10 (A - J) and 23 rows down the row heigts and you het an area

hold it against the screen res or for that matter the excel window size you van zoom it to the right size.

If someone has another idea or a simpler way please let me know..

I am even considering to have the needed area to zoom in relation to the Excel window size.

Brain excercise
 

Read other 2 answers
RELEVANCY SCORE 48.4

Hi,
I'm currently using Windows 8.1 Operating system.

I'm trying to calculate data using sql queries in Microsoft Access 2010.
Each month if the new data passes evaluation then my query adds 'Good'. If it fails it adds 'A1', but also I need to reset back to 'Good' if the data passes the next month, then recalculate again to 'A1' if it fails next month.
Please see below for an example:
Month1: Passes = 'Good'
Month2: Fails = 'A1'
Month3: Fails = 'A2
Month4: Passes = 'Good'
Month5: Fails = 'A1'
I've created queries to handle the monthly calculation, but I need some help please adding sql to reset the data back to 'Good', then recalculate.
Many Thanks.
 

A:Solved: Calculate monthly data in Access 2010

Read other 16 answers
RELEVANCY SCORE 48.4

This is an awfully strange and frustrating one.

I've been working on a formula that will compare values between sheets. ie. if the value in Sheet1 B1 match anything in Sheet2 B:B AND the adjacent value in C1 matches the adjacent value in Sheet2 column C, return TRUE.

I've gotten this formula to work in a proof of concept workbook with two sheets and about five columns worth of data. It will NOT work in another workbook where I'm comparing a 400-row sheet to a 65K row sheet. It will also not work when I break it down to a 20K row sheet. It IS able to find specific values. I can ask it to compare Sheet1!B1 to Sheet2!B375 for example, and it will return TRUE if they match. However, if I ask it to look through Sheet2!B:B for the same value (even though I know it is there on B375), it returns FALSE.

Does anyone know why this is happening, and if so can they suggest a fix/workaround?
 

A:Solved: Excel 2007 - Can't Calculate Values Between Sheets

Read other 9 answers
RELEVANCY SCORE 48.4

I use Access 2003 to produce school reports. Marks come under columns Term1, Term2 and Term3. I want to calculate the average of these term marks in column 4 just after Term3 mark. Term2 and 3 might not have any marks(when we are still in Term1 obviously) but I want the formula to count the number of fields with marks/values (Do not count empty fields) and hence calculate the average.
Using the Count function has not helped as it counts data in columns.
 

A:Solved: Calculate averages of fields in Access 2003

Read other 6 answers
RELEVANCY SCORE 48

I have a field that I want to show the total of 10 fields added together. These 10 fields have their own calculation of 2 fields added together.

Example:

Total1= Rate * Days
Total2= Rate * Days

Grand Total = Total1 + Total2

I want a Grand Total of all these into cboGrandTotal

I built the exression on the control source of cboGrandTotal as =[cboTotal1]+[cboTotal2] etc.

This does not work. I just get an empty Grand Total.

Can someone help? OBP?
 

A:Solved: Calculate Total w/Calculations in fields, Access 2007

Read other 12 answers
RELEVANCY SCORE 48

Ok here is my next problem. sorry to be such a bother.

Please look at the sample, the question will be more clear

Ok lets say I have a list of Cities.

Chicago
Des Moines
St. Louis
Indianapolis
Kansas City
Milwaukee
Minneapolis
Philadelphia

Is there a way I can get an average of work times by city without having to break them up and do them individually?
The sample is just a VERY small portion of the worksheet.
 

A:Solved: Getting an average...

Read other 11 answers
RELEVANCY SCORE 47.2

Ok so this is probably stupid easy... but I just don't use Excel to it's potential. I have a order history log and in A1-x1 I have month/day/year (mm/dd/yyyy) I want to know the average of days between orders.

ex
A1 is 10/04/2006
B1 is 10/10/2006 (6 days later)
C1 is 10/12/2006 (2 days later)
D1 is 10/17/2006 (5 days later)
etc

How do I find the average of elapsed days (6+2+5=13/3=4.3333)?

Happy Holidays!
 

A:Solved: Average between dates

Hi
Dates can be subtracted from each other, and the result is given in days.
I would use this approach:

Code:
B2=B1-A1
C2=C1-B1
.
.
X2=X1-W1
these are the elapsed days, and finally

Code:
Y2 = AVG ("B2:X2")
Is this what you need?
 

Read other 2 answers
RELEVANCY SCORE 47.2

Hi,
Is the a way to have an Average [=average(...)] formula not include cells that have no value and are outside a parameter. For example: I have a column of numbers with some cells blank and some cells either too high or too low, that I don't want to include in the average.

15
16
15
14

16
14
23
15
14
2

I don't want the blank cell and the high cell(23) and the low cell (2) included in the average. The high and low numbers will be varaible

Mike
 

A:Solved: Average formula

Read other 12 answers
RELEVANCY SCORE 46.8

Hey I need help with creating a formula for Average, but I often have 0's in the data that i don't want to count. Is there anyway i have a formula for average to only include numbers greater than 0?

See Attached Workbook
 

A:Solved: Average Calculation (Don't Include 0's)

This is one way. You can combine the two formulea in to one.
 

Read other 3 answers
RELEVANCY SCORE 46.8

I am trying to figure if there is a way to average the numbers that are showing in blue in the attached worksheet. I really don't know how to use the AVERAGE function if all the numbers aren't connected. I am using Office 2003 if that helps any.

Thanks!
 

A:Solved: Average function in Excel

Read other 6 answers
RELEVANCY SCORE 46.8

This problem is driving me mad even thought I thought it should be simple to resolve.

I have a table with monthly performance data for a number of funds. The fund names are listed in the first row of the table and the the rows below have the peformance data for each month.

To the right of this table I have created a column in which I want to calcuate the average of each month's performance but only for certain funds. I have identified these funds by placing the number 1 in the cell above the fund's name (the positioning of the ones may change)

I would like to create a formula which only takes the average of the funds's with a 1 above their name. I have attached a spreadsheet to illustrate this. The problem seems really simple but I just can't get my head around how to do this.
 

A:Solved: Calculating average of only certain cells in a row.

you can use averageIF function

=AVERAGEIF($B$2:$F$2,1,B4:F4)
 

Read other 3 answers
RELEVANCY SCORE 46.8

Hi guys

I am trying to set up a markbook type thing using excel. File attached.
There are 10 sets of mark. Each set is made up of a academic mark (%), which will be typed in by the teacher. The second column is a symbol which will add or subtract bonus marks. A=25
B=15
C=7.5
D=0
E=-15

The teacher will just type in the symbol.

The third column is a hidden column. This column uses an if function which gives the correct bonus mark as described above.

The fourth column must add the marks from the first column and the bonus marks in the third column.

At the end, there must be an average column, which must keep a running average of the marks.

My problem is this, if I use the sum function it returns a 0 value, if no values are entered. This then messes up the average value at the end. How can I enter the sum value so that if no figures are entered the total cell remains blank so that the correct average value is reflected.

Many thanks
Cara
 

A:Solved: Excel sum and average functions

Read other 16 answers
RELEVANCY SCORE 46.8

Sorry about freeky subject, I wasn't sure about my nick and paswd

Ok here is the question and it's EXCEL related. I have a long huge spreadsheet with calculated per unit cost per invoice. On monthly basis I would like to calculate the average per unit cost by using the formula =average(a0:a660). I entered that formula but it's calculating the wrong average. IT's including the ROWS which have zero balances. For example if I have only three item in one column it will still devide the total to all 660 ROWS rather then only to three existing numbers.

Any idea why? Any help will be appreciated.
[This message has been edited by Shabby (edited 12-06-2000).]
 

A:{Solved} Excel Average Function

Read other 6 answers
RELEVANCY SCORE 46.4

Is it possible to use the AVERAGE Function with cells that obtain their values by a formula? I guess what I am asking can the AVERAGE Function be sued with cells that contain formulas?
 

A:Solved: Excel Formula -> Average Function

Read other 6 answers
RELEVANCY SCORE 46.4

Hi. I have a simple formula:

=AVERAGE(I25,K25,M25,O25,AF25,AH25,AJ25,AL25,BB25,BD25,BF25,BH25)

How do I re-write the formula to ignore the empty cells that return a zero value?
All I want to average are the cells that have a number. If I delete the zero's in the cells that don't have a number the fomula returns a "#DIV/0!, which another formula picks up, therefore I have to keep the zero value and not delete them.

Thanks!
Bob
 

A:Solved: Excel Formula, Average Function...

Read other 16 answers
RELEVANCY SCORE 46.4

Hi,
I've been using the following formula for a while and just noticed the results are not what I wanted.
HTML:
=IF(a1=0,"",AVERAGE(IF(($a$1:$a$150>=12)*($a$1:$a$150<=18),$a$100:$a$150)))

What I need is to exclude any cell outside the conditions. Now it uses them as if they are 0.
As an example: If a cell is 9, it counts it as if it's 0 and uses it in the average. I don't want it to count it at all.

Mike
 

A:Solved: Average formula to exclude certain cells

Read other 6 answers
RELEVANCY SCORE 46.4

Hi,

Does anyone know a formula for the following? Any help would be great.

A simplified example of what Im looking for is:

I want to find a running average for the amount of miles I drive every week. Collumn A is the days of the week, Collumn B is the miles I drive which are added each day and in Cell C1 I need a running average.

So on Monday if I do 100 miles, C1 will be 100 (100/1)
Tuesday I do 200 miles, C1 will be 150 (100+200/2)
etc

I know there is a formula that keeps a running average in collumn C, but I need to have it in just one cell.

Thanks in advance.
 

A:Solved: Excel formula for running average

The attached has two approaches to your question.
I hope one will work for you.
 

Read other 3 answers
RELEVANCY SCORE 46.4

Hi there fellow Excel users .... here is my question:

I have researched a number of GREAT Excel sites, but my issue goes a little beyond what I am finding .. and some of the answers I am seeing go a little beyond me ... so I thought this might be the place to go.

In am trying to get rid of Div/0 errors and keep finding a neat little macro or subroutine, you may be aware of it ... but I do not know how to actually put this sub into my spreadsheet. Not even sure if I want to go the macro route ....so here is my issue:

I am using a series of data that is not congruent and using the COUNTIF function ... that is working fine, but I am averaging a series of averages (using weekly averages of some tracking numbers and then making a monthly average from those 4 or 5 averages). Some weeks there are all zeros which gives me, properly, the div/0 error ... well if any week average has the div/0 error, I then get that error for my monthly average of the averages.

If I could just get my weekly averages that equal div/0 to show up as a blank or better yet, ZERO, then I think my monthly average of averages will work out OK.

I am open to any and all suggestions. Thank you all very much for reviewing this post and possible helping out.

Don in Tucson
AizA
 

A:Solved: Excel Average/Countif/Div/0 Question

Read other 14 answers
RELEVANCY SCORE 46.4

Hi Guys,

I'm using the average function in excel however its returning #DIV/0! errors because of blank cells. Is there anyway to correct this? Part of the problem is that my cells are not consecutive so every fix I've tried is telling me i have to many arguments for this function.

=AVERAGE(C7,E7,G7,I7,K7,M7,O7,Q7,S7)

Thanks
David
 

A:Solved: Excel 2010: Average function = #div/0!

Read other 6 answers
RELEVANCY SCORE 46.4

Hi:

I need this urgently!

Trying to find the average sale per hour using number and time.

E.g:

Sales = 2

Hours worked is calculated as a difference between opening and closing time.
 

A:[SOLVED] calculating average using time and number

Read other 9 answers
RELEVANCY SCORE 46.4

Dear everyone,

I could not seem to get the formula right to calculate time-weighted average for my data. Attached is a sample of my data. I need to get the time-weighted ave for the data B3 to B16. A3 to A16 were corresponding points of time at which each datum was measured. B3 was the baseline.

I think column A cells need to be properly formatted in order to calculate the weighted average, but I don't know how.

Your input will be much appreciated.

Cheers.
 

A:Solved: Time-weighted average in Excel

Read other 9 answers
RELEVANCY SCORE 46

Hi all,

I have created the following SQL code
Code:

SELECT Contacts.ContactID, Sum(Leveringen.Gewicht*Leveringen.DrogeStof)/Sum(Leveringen.Gewicht) AS WeightedDrogeStof, Sum(Leveringen.Gewicht*Leveringen.pH)/Sum(Leveringen.Gewicht) AS WeightedpH, Contacts.Naam, Contacts.Adres
FROM Leveringen INNER JOIN Contacts ON Leveringen.ContactID = Contacts.ContactID
GROUP BY Contacts.ContactID, Contacts.Naam, Contacts.Adres;

In my datasheet I have something around 90 customers.
each customer has mutliple delivery's, with the three values Gewicht (Weight), Droge Stof (Dry matter) and pH

Now I want to calculated the weighted average for the Dry matter and pH.
The code above does this, but only with one problem.
The pH isn't filled in at every record, only in some.
It seems that the code above takes the empty record as 0 and it does take the weight of those empty records in the calculation.

So a record may look like this:
Customer x; 1400 (weight), 35 (dry matter), 4 pH
Customer x; 1500 (weight), 35 (dry matter), blank

Now it takes (4x1400)+(0*1500)= 5600/2900(weight) = 1,93 weighted pH
The average should be 4pH, (the 1500 shouldn't be taken into calculation)

How can I fix this? So that the calculation only takes those records (for pH), where the pH is also filled in. (the weighted pH is much lower at the moment than what it actually is)
The dry matter is filled in in each record, so this one doesn't have this problem. It's only for the weighted average ca... Read more

A:Solved: access: weighted average blank cells

Read other 8 answers
RELEVANCY SCORE 46

How can one (or is it not possible to) average multiple dates entered into a SINGLE Excel worksheet cell? E.g., AVERAGE(7/1/15,12/5/15). That formula does not, of course, work; no matter what dates you enter, you get "1/0/00" as the average. So is there a special way to enter the dates that will make it average them?
 

A:Solved: Average dates entered into a single cell

Read other 9 answers
RELEVANCY SCORE 46

I was able to calculate average time in my original spreadsheet in Excel 2003. However, when I copied data from that spreadsheet to another & attempted to calculate average time it doesn't work! It keeps returning the error code #DIV/0! which I assume is because many of the times I have (they are all in military time) have a zero in the beginning (i.e., 0:01:25). I would just change the time to regular time, but it needs to stay in the military format. Also, the column that the cells are in are formatted as time. What can I do to get past this?
 

A:Solved: Calculating Average Time in Excel 2003

Read other 10 answers
RELEVANCY SCORE 46

Howdy all!

I have a list of average groth, Month on Month, and want to find the overall average . . . but in accounting you usually drop the highest and lowest values to account for an abnormally high or low month.

How can I do this in Excel 2000?

I tried Median, but it is not showing the correct value

Here's the values I currently have

151%
49%
57%
-30%
44%
25%
30%
-81%
An average of all months shows 31% and Median shows 37%, but if I manually drop the 151% and the -81%, I get an average of 29%.

Basically, i want a function that will look at the range, drop the highest value, and the lowest value, then average the rest.

Any Help?
 

A:[solved]Finding average while dropping highest value and lowest value

Doh, can you believe I found the answer so soon!!!

I had been searching and working on this for over an hour, scratching my head repeatedly, and then found XL: Custom Function to Average a Range Without Highest and Lowest Values on MS' site!!

=(SUM(region)-MAX(region)-MIN(region))/(COUNT(region)-2)

replace region with the range containing the data!!

Ah well, at least it's solved now!!
 

Read other 3 answers
RELEVANCY SCORE 45.2

hey all,

for the last several months ive been on a weight loss program and i've tracked my progress using an excel spreadsheet. currently i'm using openoffice (on ubuntu) to update it but it was created in excel 2003. i have a column where i enter my weight every day and i have a cell on another page which returns my most recent entry, for the purposes of projection and trend data, etc. i know im a total nerd about it, but it has worked great. I mostly do this to improve my own excel skills.

anyway, ive been trying to figure out how to get the cell to return the average of my three most recent entries in the weight data column instead of just the one most recent entry. I've been using this function to return the most recent:
Code:
=INDEX(D58:D347,COUNT(D58:D347))
Any ideas on how to adapt that to return the second or third most recent entry? Or is there another function I can use? I know this is such a trivial problem but any help would be appreciated :')
 

A:Solved: excel - return the average of the three most recent entries in a column?

Read other 13 answers
RELEVANCY SCORE 44.8

Here's my current setup:

AMD A8-3850 Llano 2.9GHz
SAPPHIRE 100312-3SR Radeon HD 6950
CORSAIR Vengeance 8GB
GIGABYTE GA-A75-UD4H FM1 AMD A75
Windows 7 Home Premium
Antec HCG-750 750W ATX12V Power Supply

I just got this system put together yesterday (first build) and everything seems to be running fine. The only problem is I got a few games installed and the FPS is horrible and every game seems to lag really bad. I've tested it in 3 different games: World of Warcraft, League of Legends, and Civilization 5. I know something is wrong because I used to have a Geforce GTS 450 and I would get around 40-60 FPS in World of Warcraft with good-high settings. Now with this new setup it's anywhere from 11-30 usually sitting at around 30 FPS on normal settings.

The performance so far has been really bad. I have the right drivers installed. Just to be sure I had the right ones installed I reinstalled them today. I'm not sure what could be causing this. This card was supposed to have some really good performance.

I'm wondering how I can fix this, or if I have to get a new card or something. (I sure hope not)
 

A:Solved: Radeon HD 6950 performing really slow 30 fps average choppy gameplay

Can you run a DXDiag and save all the information to a text file on your desktop, then copy and paste the contents of that file into a reply (or upload the file itself)?
 

Read other 2 answers