Over 1 million tech questions and answers.

Running average in Excel

Q: Running average in Excel

I recently switched jobs and am challenged daily with new Excel spreadsheets. I have a spreadsheet with daily figures (365 rows plus weekly totals) and my boss wants to also see a running average. Is there an averaging formula that will add a new field each time so that I can copy the formula and not need to enter it for all 365 days?

Thanks for your help.

Preferred Solution: Running average in Excel

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: Running average in Excel

You can use COUNT to give you the number of cell that there are data in and use that number to create your average. Of course there is the AVERAGE function you can use on a range of cells also.

Read other 2 answers

Have looked at 2 prior 'Running Average' posts, still need help. Issue: Have two columns; 1st is 'number entry' (a new # each day), and 2nd column is the 'Running Avg'. What is the formula that when you add subsequent #s in row 1, the formula automatically adjusts for addition of new number, to then calculate the new 'running avg.' (with out changing the prior 'running averages'.) ....Thanks much.
Ann Arbor, MI

A:Excel: Running Average?

Read other 7 answers

I have percentages in a column (C3 thru Cx) updated daily. I need to show a running average of all successive daily averages. The daily and overall "process average" will then be displayed on a chart. (no problems doing that). The daily figures are calculated from two other columns that make up the %=x/y function.
I can't seem to use any of the existing AVERAGE functions to automatically recalculate the new number of cells to be averaged as they are added each day. I don't want to have to manually write in a c3,c4,c5 then next day c3,c4,c5,c6 etc. averaging sequence.

A:EXCEL: Running Average

Read other 7 answers

Any ideas on how to get EXCEL to do a running average in a pivot table?
Can't come up with anything other than superimposing some kludgy formulas on the pivotsheet.


A:excel pivot tbl running average

Read other 6 answers


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)

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

Hi! Thanks for taking the time to read my question. I have several columns of formulas where the results are random groups of numbers alternating with groups of blanks. The location and group size of the numbers varies. I would like Excel to do a running average of each group of numbers. Can you please tell me what formula I could use to do that?
Thanks again for any help you can give me!


A:Excel-Stopping and Starting a Running Average in a Column

Read other 8 answers

I am using 3 column's let's say A B and C using A and B by inputting daily numbers and the total in C by using formula =A1+B1 all the way down to 30 (monthly totals). What I want is the average on a running average from the C column. I have used the =AVERAGE(C1:C30) but all I get is the divx error.

A:Average's in excel

Read other 16 answers

Hi all I am using Excel and i am trying to work out how to do the following:
I am doing a Excell excersize for college (to be handed in when we return) and I have to use the 'PMT' function to calculate the monthly repayments of a loan in the spreadsheet - How is this done. MS Online does'nt seem to be very helpful :S

with my calculations () It has came up with -132 per month as payment which is obviously not right can anyone advise on the formula I shound be entering the spreadsheet states:

Loan amount 10,000
No. of Years 10
Annual interest rate 10%
Monthly repament = ?

The other problem with another spreadsheet i am having is I don't know how to get the average of something AND round it to the nearest whole number can anyone advise on how this would be done ?


A:Help with excel PMT and Average

Read other 13 answers

Hi Everyone,

In Excel, if I have a worksheet for each week, what is the best way to keep a running year-to-date average of a value that is in each sheet?

More detail: Each day I am tracking the hours spent on work orders and total hours on the clock. At the end of the week I calculate a "documented hours" percentage. (sum of work order ours/sum of total hours). I want to compare this week with previous weeks and keep a running ytd percentage.

I appreciate any help you can provide!

A:Excel Average Across Worksheets

Read other 14 answers


I have a large database on excel (20 000 rows), and need to calculate an average which excludes some values. I tried to use the filter tool and the auto subtotals, but it is too tedious since I need a precise summary day by day for each genre and I have too many lines to do it by hand.

Here is the format of my data :
ASIN - Date - Rank - genre

ASIN contains a product identifier, Date the date when the data was taken, rank the value to be computed and genre is a classifier. I want to automatically compute the average rank of a given genre day by day. Any idea how I could do that?

Here is enclosed a sample data if you want (two days included, bear in mind that the number of product by day may change).

A:Difficult average on excel

Read other 16 answers

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.


A:Solved: Average function in Excel

Read other 6 answers


I have an Excel worksheet with columns C - H showing dates, with C being the most recent and H being the earliest.

Most rows have values in all date columns, but some have less than 6 dates

I want to find the average time between the dates, in days, and fill into Column B.

I have not been able to figure this out. Can anyone help?!

Thanks so much. I attached a workbook with some example rows.

Read other answers

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

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

A:Solved: Excel sum and average functions

Read other 16 answers

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

hi i just built my computer it has intel pentium 4 3.4Ghz and intel motherboard and Geforce 6600 graphics card. 1GB ram. now im using a Intel(R) Desktop Utilities. and is telling me that my cpu is around 75C and i dont thing thats normal. i am using the fan for the cpu that came with it which i dont recon is doing a good job. my case has a fan on the side and thats about it. i was thinking about this on ebay http://cgi.ebay.com.au/Copper-Heats...0096127374QQcategoryZ3673QQrdZ1QQcmdZViewItem do you recon that would cool it down alot. Because my pc is ment for gaming and if its runing 75C just using internet explorer then thats a problem to see what it runs on a game. so could you please tell me if that fan will be ok and mabe tell me what tempurature it would be if you could that would be great thank you very much.

or this one http://www.umart.com.au/newindex2.phtml?bid=4 and http://www.umart.com.au/newindex2.phtml?bid=4

thank you very much

A:please help new here CPU running 75c average

75c is way too hot to be near-idling at. Is this the first time you've built a computer? I'm betting you installed the HS/F wrong. You're going to need to take off your HS/F, reapply thermal paste, and install the HS/F correctly.

Read other 39 answers

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

Hi. I have a simple formula:


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.


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

Read other 16 answers

Dear Excel Gurus,

I have an Excel 2010 spreadsheet containing data under columns A and B. I want to add a third column (C) and to have Excel populate the fields under C with the averages of readings listed under the B column for each site_id, like I show below:

site_id reading average
3457701 257 315.508
3457701 350 315.508
3457701 401.6 315.508
3457701 354.3 315.508
3457701 214.64 315.508
3458904 183.05 200.276
3458904 267.13 200.276
3458904 173.25 200.276
3458904 203.30 200.276
3458904 214.64 200.276
3458904 207.16 200.276
3458904 224.66 200.276
3458904 104.63 200.276
3458904 224.66 200.276
3460205 100.00 150.000
3460205 200.00 150.000
3458904 240.33 240.33
and so on for some 130,000 rows of data

Any help would be appreciated.


A:Excel 2010 question on AVERAGE function

Read other 11 answers

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.



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

Read other 6 answers

Sheet one contains two different columns of data
Sheet two is =IF(Sheet1!O3>0,Sheet1!O3*Sheet1!$I3,"")
I copied the above cell into several places.
Average function for columns. Average works fine for some columns but not others. If I do a sum/count function on the incorrect columns, the correct answer is returned. It appears as though the count part of average sometimes doesn't work. What's even better, in column with all empty cells, some average functions show an empty cell, others, show {#DIV/0!}

A:Excel 2000 - Incorrect Average Calculation

Read other 6 answers

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.


A:Solved: Time-weighted average in Excel

Read other 9 answers

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

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

Read other 14 answers

I would like to record amounts in Excel 2003 in one column along with the date of the amount. I then want to view a chart of the amounts for the month, quarter, or year. However I will have missing amounts for some of the days. I want excel to calculate an average for the missing amounts. Here is an example of data.

Date Amount
3/1/2016 10.00
3/2/2016 20.00
3/3/2016 0.00
3/4/2016 8.00
3/5/2016 6.00
3/6/2016 0.00
3/7/2016 0.00
3/8/2016 18.00
3/9/2016 0.00
3/10/2016 15.00
3/11/2016 0.00
3/12/2016 19.00

Maybe I would not care to make an entry if there is no amount that day but still want to see it averaged between the two given amounts.

A:Excel 2003 average data in charts

Maybe I should be using Access, log in Excel and transfer to Access.

Read other 2 answers

Well, I've scheduled an appointment for the ISP to come out. But in the mean time, is there anything you guys reccomend to speed up my connection?

A:Cable running at 50% of average

Read other 6 answers

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

Hi guys.
I'm sure I'm making a meal of this, and it should be really easy...

I have an Excel file that has a list of contiguous dates in column B and values in column C.
The date in B2 is a 15/08/2016 (UK date format), which is a Monday.
In col D, I need to enter a formula that gives an average of the values in C column for the corresponding week.
In other words, the formula result should be the same in cells D2: D8, as it is the average of the values in C2:C8.

The date in cell B9 (22/08/2016) is a Monday again, so the average is now for the next week - i.e. in cells D9: D15 the formula result should be the average of the values in C9:C15.

I can do this manually by entering absolute references following in cells D2: D8:

=IF(ISERROR(AVERAGE($C$2:$C$8)), NA(), AVERAGE($C$2:$C$8))
And then in cells D9: D15

=IF(ISERROR(AVERAGE($C$9:$C$15)), NA(), AVERAGE($C$9:$C$15))
And so on.

However, this means manually modifying the formula for each week. I'm sure this can be done better by using formula to 'roll' the average once a week, using a combination of IF, WEEKDAY (or WEEKNUM) and OFFSET...


A:Excel formula - A weekly average that rolls on a Monday?

Hi @Gram123, I suggest you upload a sample file with non-private data, makes it easier to understand.

Read other 1 answers

I was just wondering what is an average number of processes running after restart before you start anything else up. I usually have around 44 running and this seems excessive. I would love to know what a minimum number of processes is to run Windows XP. If you have an idea, please let me know.


Process worrier!

A:Average number of processes running

Read other 10 answers

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:
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

I have tried everything that I can think of. I am still having problems with my computer running at below normal speeds for example. I bought the SIMS2 the other day and it requires an 800 Mhz Processor mine is 1.7 Ghz it requires 256 Meg Ram I have 384 Megs and at least an 8 speed Cd drive I have a 48X. It ran so slow I couldn't do anything it was so Choppy and erratic that I finally decided to try loading it on my kids PC to see what would happen they have 256 megs of ram a 48X cd Drive and only a 450 Mhz Pentium 2 processor. Remember it requires at least an 800Mhz processor. The game runs perfectly with an occasional skip in the game play that is barely noticeable. Now please tell me how that is possible. Thank you in advance for your responses

A:Problem with Computer running at below average Speed

Do you have a real-time checking Antivirus program installed?

Also have a look in MSConfig, to see what programs are always running. If you can, report that here.

Read other 6 answers

Hi all,

Just wondering: I run my PC on an average no-name brand UPS to safeguard against sudden power outages. Not so uncommon in my part of the world so almost a necessity, not a luxury. Problem is that the UPS is nothing special while my PC is a power sucker - GTX780 Ti Super clocked, core i7 4770K over clocked, several USB devices, 2 SSD's and 1 HDD, multiple fans etc. All fed by a Corsair 1050W PSU. Will the UPS potentially reduce performance of the PC or cause it to BSOD if it cannot deliver enough power? It has not happened yet. Or does it not matter as long as the UPS is being fed from the wall plug?

A:Running an average UPS on a modern high powered PC

Running a high powered PC with a cheap UPS doesn't make much sense. Any UPS is going to have a maximum power rating, and with a cheap one the actual capabilities may not match advertised specs. If at any time the UPS is unable to supply the required current there are going to be problems. That means possible spontaneous shutdowns, BSODs, or damage to either the UPS or computer.

Not recommended.

Read other 4 answers

I am currently trying to build a spreadsheet for calculating an individuals production level based on a few criteria:
Must have worked 18 or more hours for the week, anything under 18 hours can't count toward production

Must be the most recent 4 weeks included in the average (anything in the previous weeks must be ignored)

I will be linking a work in progress workbook with some sample numbers, but here are the basics:
I am attempting to calculate a weighted average for both production (hours for the week vs.% of Standard achieved) level and accuracy (units vs accuracy) in I4 and I5 respectively. Production can only be considered valid if an associate reaches 18 hours in that job function. Each week I have to insert a new set of data identical to the previous week, but with updated values. I don't mind manually updating the very simple formula that would be required to find this value, however this is something that I need to share with several non-excel savvy people in my area.

I am hoping that there is a macro out there that would auto-magically appropriately update each of the averages whenever a new week is added to the spreadsheet.

I am a novice when it comes to macros, but I would appreciate any help. Thanks

Read other answers

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

I'm trying to run an executable file I've created in Fortran from Excel. I'm new to this, but it seems like it should be possible. However, I can't seem to find information about how to go about doing so.

If anyone can help me get started or link me somewhere with appropriate information, I'd appreciate it.

A:Running .exe from Excel

Read other 15 answers


I have two excel worksheets. The first one keeps track of a running average. The second sheet has one row of data to which I add data to every day. Currently, i have to keep changing the first worksheet average function in the cell to include the second worksheet's new cell of data in that row. Is there a way to automatically have the first worksheet to detect the second sheet's new data addition and figure it into the average without manually changing the average range??? It wouldn't be a problem to do it manually except i have to do it for around 50 different rows everyday i add data.


A:running averages in excel

Couldn't you just reference the entire row (Sheet2!A:A)? Or am I missing something?



Read other 3 answers

ok here is my problem. i'm trying to set up a simple ledger with a running balance and i have got to the running balance and all totals are working but the problem is the in the balance column it has the balance in all the cells. what i'm looking for is to not have the balance in the balance column untill there is and entry in either the credit or the debit column. i'll attach it so that maybe it will be a little more self explaining. i have played around with the "IF" funtion but i'm not real familure with excel and still really learning it.

Thx for any help

A:running balance in excel 07

I am by no means an authority of MS Excel, but I did have a similar question as yours some time back and one of the folks at this site helped me with this answer. Hopefully it will help with your situation.
Enter in Balance cell E4 the formula below, click and drag on down.

Read other 3 answers

hi all,

i have created a spreadsheet for my wifes new business using excel. its a simple spreadsheet for keeping a record of her expenditure. (receipts etc). i created a column for balance and was able to enter a formula so the balance would automatically update as she entered new receipts.

however, a couple of things i cant get around:

1) the last total runs all the way down the page which i don't want

2)if i delete something say, halfway down, it messes up everthing below it because it relies on the formula which has been copied and pasted from above.

tell me if im not clear and i will try to clarify, with screenshots or whatever

thanks in advance

A:running balance in excel

Read other 16 answers

My macro stops running and there is no error msg. My macro basically copies formulas contained in 5 cells from one spreadsheet to another but the macro just stops running after it pastes the data. No error msg. I've tried running the macro step by step and it stops running at the exact same place. If I either run the macro again or keep pressing F8, the macro begins again from the start of the sub procedure and runs completely (doesn't stop). I don't understand why it's stopping the first time I run the macro.

Here is the code:

Windows("Fund Dilution Macro.xls").Activate
Application.CutCopyMode = False
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

After the macro pastes the data from the first spreadsheet, it just stops running. When I am running through the macro step by step (using F8), the yellow right arrow that you usually see on the left hand side of the row of code that is running just disappears after the "ActiveSheet.Paste" line (highlighted in red above).

A:Excel Macro Stops Running

Hi, wlecome to the forum,
I imagine this is not all of the macro but there are no further actions here and I can't see what else follows
What is Naddilac.usr? well not much to say with this info.

Read other 1 answers

I have read of many problems trying to get Excel or Office 2007 to work in Windows 10.

I have just aquired a new desktop PC with Windows 10 and at first copied across my Office 12 to the Microsoft office file, however it wouldn't run.

So I installed my original copy of Office 2007 and it now runs Excel and Word okay.

However I can open them with a shortcut and the select to open any file from the program, but if I select a folder with say an excel file and double click it to open, it shows a blank Excel 2007 spreadsheet.

If I try to select open with... it only shows Excel 2016 as an option, no Excel 2007

Anyone know how to fix this?

Read other answers

I can run this macro on my own machine but when I transfer it to another computer, I get the following error: Run Time error 1004 Cannot open PivotTable source file 'headcount by area' - any ideas what's wrong??!

A:Error running a macro in Excel

Read other 6 answers

I have quite a few macros written in older versions of excel that now won't run on our Windows 7 machines. Getting the error that the library is not found. I assume this is an issue with the new "Library" function in Windows 7. Does anyone know what to do to run these? From what I have found, there is not a way to turn off the Library function.

A:Running old Excel macros in Windows 7

It is more than likely referring to a missing .dll file...not the Libraries (folder groups) in Windows 7. What version of Excel where they created in...and what's installed on the new system?

Read other 2 answers

How do I set a macro to run every time a particular spreadsheet is open? I have it in a module now for the worksheet but I can't figure out how to run it without user intervention.

Also I know that I can open Excel within Access but is it possible to open the above mentioned spread sheet only?

Building the Ultimate site list for PC support.

A:Running an Excel macro on open.

Read other 6 answers

Well...current XP excel doc has auto invoice numbering that does not work on Vista. We have spent 10-20 hours trying to solve this reviewing forums and deep diving into Vista libraries. Would I be better off creating a new Excel doc with Auto numbering on Vista? Is this possible on this magnificient OS? Thanks

Read other answers

Hello all

My problem is that I have put together a stop watch in which I want 2 bits of animated text to start at the same time as I click the button to start the stop watch. I currently can only get it to Call the animations and so it runs both animations in order and then starts the clock. Is it possible to get these working together at the same time?

My code so far is as follows;

Public StopSW As Boolean
Public ReSetSW As Boolean
Public SplitSW As Boolean
Public myTime

Sub stopwatch()

Call Animate_String1
Call Animate_String2

'Seconds and fractions of seconds Timer!
Dim Start, Finish, TotalTime
Dim myHi!, myH%, myMi!, myM%, mySi!, myS%, mySf!, SubTotalT, newTime
'Set timer.
Start = Timer
StopSW = False
ReSetSW = False
myTime = Sheets("Sheet1").Range("AA1").Value
'Yield to other processes.
'Calculate time.
Finish = Timer
TotalTime = Finish - Start
SubTotalT = myTime + TotalTime
myHi = Application.WorksheetFunction.RoundDown(SubTotalT / 3600, 0)
myH = myHi
myMi = Application.WorksheetFunction.RoundDown(((SubTotalT - (myH * 3600)) / 60), 0)
myM = myMi
mySi = Application.WorksheetFunction.RoundDown(SubTotalT - ((myH * 3600) + (myM * 60)), 0)
myS = mySi
mySf = SubTotalT - ((myH * 3600) + (myM * 60) + myS)
newTime = Format(myH, "0") & " :" & Format(myM, "0") & " :" & _
myS & " H:M:S"
'Sh... Read more

A:Running more than one macro at the same time in Excel

Read other 16 answers

i think i've finally figured it out this is so weird.. why my comp has been really slow and been doing weird things.. like when im playing starcraft and i try to type it keeps minimizing starcraft
excel is on my processes and i can't get rid of it and i never use my excel program anyway.. how could excel really take up that much cpu?
But it only does it sometimes.. I have no idea

here's my hijack this log

Logfile of HijackThis v1.99.1
Scan saved at 12:54:13 AM, on 6/26/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP1 (6.00.2900.2180)

Running processes:
C:\Program Files\Common Files\AhnLab\ACA\ACAAS.exe
C:\Program Files\Common Files\AhnLab\ACA\ACAEGMgr.exe
C:\Program Files\Common Files\AhnLab\ACA\ACAIS.exe
C:\Program Files\Common Files\AhnLab\ACA\ACALS.exe
C:\Program Files\AhnLab\Smart Update Utility\AhnSDsv.exe
C:\Program Files\AhnLab\V3IS2007\MSProxy.ahn
C:\Program Files\Common Files\Authentium\AntiVirus\dvpapi.exe
C:\Program Files\NVIDIA Corporation\NetworkAccessManager\Apache Group\Apache2\bin\apache.exe
C:\Program Files\NVIDIA Corporation\NetworkAccessManager\bin\nSvcIp.exe
C:\Program Files\NVIDIA Corporation\NetworkAccessManager\bin\nSvcLog.exe
C:\WINDOWS\s... Read more

A:excel is taking up half my cpu and im not running it

Do a HijackThis scan & place a check next to these items and select "Fix checked":

O4 - HKCU\..\Run: [Barbossa] C:\WINDOWS\system32\mi090118\088501\860046\343231.vbs


Then navigate to this folder - C:\WINDOWS\system32\mi090118
Zip/archive the folder & then submit the folder to this website - http://www.bleepingcomputer.com/subm....php?channel=4


Please perform an online scan using Internet Explorer at http://www.kaspersky.com/virusscanner

Answer Yes, when prompted to install an ActiveX component. The program will then begin downloading the latest definition files.
Once the files have been downloaded click on NEXT
Locate the Scan Settings button & configure to: Scan using the following Anti-Virus database:Extended

Scan Options:Scan Archives
Scan Mail Bases
Click OK & have it scan My Computer
Once the scan is complete, it will display if your system has been infected. We only require a report from it.
It does not provide an option to clean/disinfect.
Click the Save as Text button to save the file to your desktop so that you may post it in your next reply
* Turn off the real time scanner of any existing antivirus program while performing the online scan

Note for Internet Explorer 7 users: If at any time you have trouble with the accept button of the licence, click on the Zoom tool located at the right bottom of the IE window and set the zoom to 75 %. Once the license accepted... Read more

Read other 1 answers


I had experience these BSOD's when running EXCEL 2010. Is happening once a day or after few days.

The computer is using Windows 7 Professional 64bit with Office 2010 Business 64bit. Both licenses are FPP (full package product).

The computer is an AMD quad core with 8GB ram, gigabyte mobo and gigabyte video. Is having a SSD Corsair sata3. For full computer description I added to the zip file a SIW Freeware report as html file. You can see into the html file all software installed and also specific info regarding hardware. More than can I describe in the topic post. Hope is helpful.

What to do? I hope that you can help me because this computer is running some excel sheets with calculations and is annoying to stop working because of an error.

Thank You in advance.

A:BSOD running Excel 2010


Microsoft (R) Windows Debugger Version 6.11.0001.404 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.

Loading Dump File [K:\BSODDmpFiles\organizator\Windows_NT6_BSOD_jcgriff2\013012-10654-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available

Symbol search path is: SRV*c:\symbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows 7 Kernel Version 7601 (Service Pack 1) MP (4 procs) Free x64
Product: WinNt, suite: TerminalServer SingleUserTS
Built by: 7601.17640.amd64fre.win7sp1_gdr.110622-1506
Machine Name:
Kernel base = 0xfffff800`0300f000 PsLoadedModuleList = 0xfffff800`03254670
Debug session time: Mon Jan 30 07:14:38.112 2012 (GMT-7)
System Uptime: 0 days 1:52:50.285
Loading Kernel Symbols
Loading User Symbols
Loading unloaded module list
* *
* Bugcheck Analysis *
* *

Use !analyze -v to get detailed debugging information.

BugCheck 1E, {ffffffffc00000... Read more

Read other 3 answers

Hey all,

I am looking for a way to run excel with a permanent processor affinity in windows 7. I've found a few options, such as a temporary registry hack (would've worked if it was permanent), a power shell command (which would work if there was a way to make windows run the script every time excel was opened), and a batch file shortcut. None of these things quite address the my problem.

No matter how excel is opened (a.k.a. whichever shortcut, file, or script is used to open it), I want the processor affinities automatically assigned without user input. Back in XP the registry hacks were permanent, so those were pretty awesome, but I don't know how to rig something like that up in 7. Any advice you guys could provide would be appreciated.


A:Running Excel with specific processor affinities

Hello Ashi,

You should be able to use the method in the tutorial below to create an Excel shortcut that will open and run with the set CPU affinity.

CPU Affinity Shortcut for a Program - Create in Windows

Read other 2 answers