Over 1 million tech questions and answers.

Average If and #DIV/0!

Q: Average If and #DIV/0!

In my sheet I am using conditional formating to return 4-color traffic lights (using number 0-3). At the bottom of each colum I want the average of all number 1-3, excluding any 0s. I am using the formula =AVERAGEIFS(I3:I8,I3:I8,"<=3",I3:I8,">=1").

This is providing the correct answer unless it is a column of all 0s. How can I have the current formula I am using but also if the answer is #DIV/0! for it to return a zero instead of the error message?

An example of what I am doing is attached. Thanks for your help.

RELEVANCY SCORE 200
Preferred Solution: Average If and #DIV/0!

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: Average If and #DIV/0!

Read other 6 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 37.6

Want to bring the Avg Amount, using IF Formula for the below calculations.
This Sheet 2
ColumnA Column B
Grade Group
Avg Amount
A&B
This Sheet 2
C&D

E&F

G&H

I&J

Total


The below data is on Sheet 3 from where the data needs to be taken for the above function
Employee Code
Employee Name
Grade
Amt
0020
Tom
B
24970
0024
Dick
I
24970
0030
Heera
B
24970
3933
Hari
I
10822
3935
P C
C
10822
3936
Vivek
J
10822
3937
Keni
G
10822
0115
atil
D
24970
3939
Swam
J
10822
0166
Samir
A
24970
3940
Taran
H
10822
3941
Sathya
G
10822
3942
Seem
A
10822
0236
Santos
G
24970​

Can u please help me with the Average if function.
 

A:Average IF

Read other 7 answers
RELEVANCY SCORE 37.6
Q: average

I am using access 2000 and have a query with the length of stay for 14 clients..What is the best and Easiest way to calculate the average
 

RELEVANCY SCORE 37.6

Got the desktop working recently, but I'm a tad concerned, the CPU at idle sits

in the 29-32C range and goes up to about 40C when I'm playing Microsoft Train

Simulator with [email protected] and other apps in the background. The CPU is at stock

speeds and Rambo says his maxes at 45C and his is at 3.03GHz.

Do I need a case fan to help get the air circulating in the tower box?
__________________
Free Offers Stock Market Charts
 

A:Average or hot?

Read other 6 answers
RELEVANCY SCORE 37.6

I'm trying to make a program to calculate the average of grades, can anyone please explain what I'm doing wrong?

#include <iostream>
using namespace std;
int main(int argc, char* argv[])
{
int x,y;
int *p;
int total=0;
int average= total / x;

cout << "Please insert the number of scores "<<endl;
cin >> x;
p= new int[x];
for (y=0; y<x; y++)
{
cout << "Please enter a score: "<<endl;
cin >> p[y];
}
cout << "The scores are: ";
for (y=0; y<x; y++)
cout << p[y] << ", ";
cout<<"The average is: ";
for (int y=0; y<x; y++)
{
total += p[y];
}
delete[] p;
system("pause");
return 0;
}
 

A:c++ average help

Read other 6 answers
RELEVANCY SCORE 37.2

My desk top is approx 4 years old , and things are starting to go !

Google Chrome gives me an error and freezes up , Everything else seems to work, so I switched to Yahoo..
IS THIS NORMAL ????

A:Average Life.

No this is not normal, but many people "refresh" their installation after some time (years).
Can you please fill in your System Specs?

Read other 6 answers
RELEVANCY SCORE 37.2

What is the average life of a cd drive
 

A:Average life of cd rom

Read other 7 answers
RELEVANCY SCORE 37.2

Hello all!

Some of you may know me. Like my software and WinSxS (I love the way WinSxS all fits together!) but am utterly clueless about the hardware. Please forgive me this question!

I have a DESKTOP PC which is NOT overclocked in any way. It is reasonably powerful (see specs) and is a Dell. However, it is used to the extremes of its ability - regularly.

I would just like to ask you what the temperatures you would consider good, warm, and hot for both the GPU and CPU. I know the GPU can get quite hot, but I would please like to know how hot, so that I can learn.

I have a feeling that mine are quite hot. Most of the time I get:

CPU: 52 degrees Centigrade (C)
GPU: 128 C

These seem awfully hot. Putting my hand on the GPU plastic casing after use makes me think that these are not anomalous!

Thanks so much in advance!

Richard

EDIT: All of the fans have been confirmed as working, and it has good airflow all around, and always has had.

A:At what temperature does an average CPU and GPU become too hot?

Hello Richard, I am not really knowledgeable in this area & can only reflect on my own research so that i can monitor my own temps which basically indicates 70 degrees C and below in both cases as being comfortable temps.

In posts i have read concern is usually expressed in 80c+, your CPU looks fine mine runs at 50-65 & max 72c under heavy load. I use Core temp to monitor which also has overheat protection

http://www.alcpu.com/CoreTemp/

The tjmax is the CPU manufacturers max temp (assume critical) & safe temps to be 15c-20c below this.

As far as your GPU it looks extremely hot but i do not have a solution for you other than cleaning & extra cooling which i am sure you are already aware of. (my desktop has settings in the BIOS for the fan)

Here are my temps which are for a laptop;

Read other 23 answers
RELEVANCY SCORE 37.2

I did a search and found 2 similar named threads, but neither seemed to pretain, so, I'm starting a new thread.

I'm a computer consultant, but I've run into an interesting situation. I have a WinXP Pro system 3.4ghz LGA processor 1 gig of DDR400 ram, 2 100+ gig HDs, a CD Burner, and a DVD/CD Reader, Nvidia GeForce 5700LE (256) video, SP2, and all latest updates installed.

Many programs installed. I've got Norton AV Corporate 8, AVG Free 7.0.323, Spybot 1.4, Adaware 1.06r1, Spyware Blaster 3.4, with all the lastest updates. Adaware found 7 tracking cookies, Spybot says I'm clean, Blaster is updated with no errors/problems. AVG and Norton run daily and show no virii.

What is occuring is when I leave my system sit with any program running either in the background or foreground, for 20 minutes or more, the system will bog down. When I check the Task Manager, it shows Explorer.exe floating between 48-50%, with memory jumping around. 160,000 - 280,000K, thought it was climbing but watched it and it keeps fluctuating. System.exe is showing 30-40%. It doesn't matter what program I may leave running, from WinMX to MS Word 2003.

The only way to clear it is to log out. I don't have to reboot, just log out of the shell. Logging back in and the system runs great. Now, if I have say WinMX going, typing a report in Word, have IE going doing a search... moving around the system, active, the system seems to run fine, I don't notice any slow-down, but if I leav... Read more

A:Explorer.exe using on average 50% CPU

Think I would try an online virus scan to make sure Norton and AVG have not missed something. I would also try Mirosoft Anti Spyware.

There are indexing programs that run to index the hard drive when it thinks the system is idle. Microsoft Office comes with find fast. Some of the desktop search programs use this also. Check msconfig for these programs and uncheck them.

Read other 9 answers
RELEVANCY SCORE 37.2

Hi:
can anyone figure out why the sum and average isn't displaying based on what the user enters? it runs and i get values of 0 for each sum and average...any help by MIDNIGHT WOULD BE GREAT!

Code:

#include<iostream.h>

int main()
{
int y, i;
double g, m=0, a;
cout << "Please enter number of values to be processed: ";
cin >> y;//receiving number of values
cout << "Please enter the " << y << " values:\n"; //asking for those values
a = m/y;
for(i = 1; i <= y; i++)
{

cin >> g;
g += m;
}

cout << "Sum: " << m << "\n"; cout << "Average: " << a << "\n";
cout << "Thank you come again!";
return 0;
}
 

A:C++ Sum & Average not working

Here ya go.

BTW, I suggest using var names that
give you an idea of what you're doing,
such as "total", "numentries", etc.

int main()
{
int y, i;
double g, m=0, a;
cout << "Please enter number of values to be processed: ";
cin >> y;//receiving number of values
cout << "Please enter the " << y << " values:\n"; //asking for those values
for(i = 1; i <= y; i++)
{
cin >> g;
m += g; // Add entry (g) to total (m).
}
a = m/y; // divide m (total) by y (number of entries)
cout << "Sum: " << m << "\n"; cout << "Average: " << a << "\n";
cout << "Thank you come again!";
return 0;
}
Hope I'm not doing somebody's homework here...
 

Read other 1 answers
RELEVANCY SCORE 37.2

Just recently moved to a new apartment and had to ditch my dsl for cable. I got the highest service available which was 1536kb/512kb. Now when I do the bandwidth tests on websites I can only get anywhere between 150-200kbps. I had a tech com over here and hook it up correctly, or so it seemed, because it was going very slow to start with. He showed me it was working by downloading a 100mb file and the transfer rate was hitting from 150-250 KB. Just wondering why it is that the internet seems soooo utterly slow but most of the downloads are realitively fast. Maybe I am misunderstanding some term or something but I know this cable line should be higher on the BW tests than 150-200 kbps! I have tried 8 seperate tests to check and all were about the same.

Thanks in advance,
Jim
 

A:Why is my speed so below average?

Read other 14 answers
RELEVANCY SCORE 37.2

Is 89C for a NVIDIA GeForce 6800GT a high temperature?
 

A:Average Temp for my GPU?

Read other 6 answers
RELEVANCY SCORE 37.2

Well... I recently notice some lag on my computer and went over to Speedtest.com to check my speed on the computer. With the results calculated, It said that I'm below the average ISP Provider speed and from before tests i have.

My Average Download Speed Before: 17.64 mlbs
ISP Average Download Speed: 7.34 mlbs
My current Average Download Speed:4.08mlbs

My Average Upload Speed Before: 0.48 mlbs
ISP Average Upload Speed: 0.54mlbs
My current Average Upload Speed: 0.41mlbs
-
With these results tests a couple of times it seems like my computer is need some tune up. Help?
-
OS: Windows 7
*Don't suggest buying a new computer because I bought this computer this year
-
Please Reply ASAP, I'm experiencing major slowness and have work to do on the computer, I will check daily if you havn't post anything yet but if you did I will check this thread every minute.
Thanks
-Yamato
 

A:Speedtest Below Average?

Read other 7 answers
RELEVANCY SCORE 37.2

hi i am new to programming and try to make an average function with several variables, but got stuck
can someone help to solve. see attach file
 

A:help with vba macro average

some additional info for request.
20 colums B, D, F etc.from each column i want average of 2, 3,...., 20 last cells
averages of first column on another worksheet(averages) in E6:W6
averages of second column in E7:W7 etc.
 

Read other 1 answers
RELEVANCY SCORE 37.2

Hello all!

Some of you may know me. Like my software and WinSxS (I love the way WinSxS all fits together!) but am utterly clueless about the hardware. Please forgive me this question!

I have a DESKTOP PC which is NOT overclocked in any way. It is reasonably powerful (see specs) and is a Dell. However, it is used to the extremes of its ability - regularly.

I would just like to ask you what the temperatures you would consider good, warm, and hot for both the GPU and CPU. I know the GPU can get quite hot, but I would please like to know how hot, so that I can learn.

I have a feeling that mine are quite hot. Most of the time I get:

CPU: 52 degrees Centigrade (C)
GPU: 128 C

These seem awfully hot. Putting my hand on the GPU plastic casing after use makes me think that these are not anomalous!

Thanks so much in advance!

Richard

EDIT: All of the fans have been confirmed as working, and it has good airflow all around, and always has had.

A:At what temperature does an average CPU and GPU become too hot?

Hello Richard, I am not really knowledgeable in this area & can only reflect on my own research so that i can monitor my own temps which basically indicates 70 degrees C and below in both cases as being comfortable temps.

In posts i have read concern is usually expressed in 80c+, your CPU looks fine mine runs at 50-65 & max 72c under heavy load. I use Core temp to monitor which also has overheat protection

http://www.alcpu.com/CoreTemp/

The tjmax is the CPU manufacturers max temp (assume critical) & safe temps to be 15c-20c below this.

As far as your GPU it looks extremely hot but i do not have a solution for you other than cleaning & extra cooling which i am sure you are already aware of. (my desktop has settings in the BIOS for the fan)

Here are my temps which are for a laptop;

Read other 23 answers
RELEVANCY SCORE 37.2

Hi all! Would you all please tell me what is the temperature range that your P50 or P70 typically operates at?   It would also be great if you could measure it under average office use, internet browsing, plus maybe picture/video editing or low-to-mid-level gaming (if you do those sorts of things).  Also, to circumvent potential confusion, please denote what machine you have and in what scale you are getting these temp readings.




-----------IBM T40: XP PRO SP3, 14.1" 4:3 display, 512MB DDR RAM, 40GB HDD, ThinkLight, DVD.Lenovo Ideacentre H215: AMD Athlon II X2 215, 500GB HDD, 4GB DDR3 RAM, 64-bit Win7, AMD 760G.

Read other answers
RELEVANCY SCORE 37.2

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
RELEVANCY SCORE 37.2

i'm getting an average of 57FPS when i'm playing Oblivion but still have freezes, each freeze last for about 1 sec or less but it happen frequently and it's so annoying, do u think it's a compatibility issue...
thanx....
 

A:Average of 57 FPS but still a problem

OneZ said:



i'm getting an average of 57FPS when i'm playing Oblivion but still have freezes, each freeze last for about 1 sec or less but it happen frequently and it's so annoying, do u think it's a compatibility issue...
thanx....Click to expand...

You are running a very graphic intense game, remember. How often does this happen? What are your system specs?
 

Read other 7 answers
RELEVANCY SCORE 37.2

Hello all,
I have an Asus motherboard P5Ld2 with Intel socket 775 3.0 hypertreading,3 Gb of ram, 2 Sata hard drive, Asus EN6600 256Mb videocard.standard intel cpu fan with 3 case fan.
My temperature for the board is average 38 degrees C and for my cpu between 50 degrees to 70 degrees.Is this normal?
Lately i noticed that my computer was extremely slow at times.Should i buy a better cpu fan?
If so, any suggestion?
Thank you for answering.
 

A:average cpu temperature

First off, what Intel CPU do you have (sorry, I can't tell what cpu it takes from looking at the model # like some members :unch: )? In some cases this is normal, and in some this isn't. You board temp is fine overall, I just wonder about the cpu.
 

Read other 9 answers
RELEVANCY SCORE 37.2

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
RELEVANCY SCORE 37.2

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 37.2

Sup guys i've recently invested in a desktop PC for my son for him to do some light gaming on.

The specs are:

Pentium D [email protected]
2GB DDR2 @ 667MHz
Nvidia GT220 1GB DDR3
160GB 7200RPM

He'll be playing things like World Of Warcraft, Garrys Mod etc, nothing too straining... Will this computer run those games fine?

Thanks
 

A:Average gaming rig?

Well first I want to ask, how much did you pay for it? Passed that I'll say he should be able to play on low to medium settings with okay frame rates.
 

Read other 5 answers
RELEVANCY SCORE 37.2

Hi all I was just wondering what the safe operating temp. on a video card under load with the higher end games and video cards. thanks!
 

A:Average heat on a GPU

That depends on the GPU and the cooling methods used.

If you are looking for comparison figures, it would be helpful if you provided us with the GPU specifications in your machine.
 

Read other 4 answers
RELEVANCY SCORE 37.2

I've been blowing through graphics cards about every 12 months. Even with my new system it's been the same. I do play a lot of graphic intensity games. Could that be the reason for their early demise? The latest casualty is my GTX 560.
 

A:The average life of a GPU

A GPU's lifespan is at least 3-5 years. Hell, if you take care of your components it will last as long as you need it to in most cases. The fact that your GPU's are dieing in a year is strange. If this has indeed happened to all of your GPU's it is safe to say that the operating conditions inside your PC may not be too good. Or, you may just be burning them out? Do you SUPER overclock them or something? What sort of operating temps do you usually get?
 

Read other 27 answers
RELEVANCY SCORE 37.2

what is the average cpu temp. without getting it too hot when overclocking?
 

A:Average cpu temp.

Way cool!

Check out this thread and this forum
Read Before Asking "Is This Too Hot?"
Should help you find info.... :hotbounce
 

Read other 1 answers
RELEVANCY SCORE 37.2

Hello,
Whats the best PSU to get? I had a 300W one and changed last week for a 450 Low Noise PSU. I know I wont need 450W and it will probubly do me no differernce but is it worth having that extra bit more? I was going to get the 600W one but it was faulty, so I had to take it back and get the 450W one. I think 300W is plenty, What you guys think?
 

A:Average PSU Power

It depends on your system specs. Can you give us your full system specs?

You can check THIS THREAD to help you.
 

Read other 9 answers
RELEVANCY SCORE 37.2

Dear HP Computer On November 3, 2016 morning, I sent my HP desktop computer (Windows10 and MS Office installed) to HP Service Center Jakarta.  In front of the HP service personnel, I backed up the data from hard disk as it was the only suggestion given.  The computer was in working condition when HP service personnel took it over. On November 7, HP service officer called and said the computer had no problem, and he just needed to fix some files.  On November 8, I picked up the computer.  At home I found out that the system was "downgraded" to Windows8 and MSOffice was "not properly"installed. As this was a paid service, I think this service was below average of typical services provided by HP. cw  

Read other answers
RELEVANCY SCORE 37.2

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 ?

Thanks
 

A:Help with excel PMT and Average

Read other 13 answers
RELEVANCY SCORE 37.2

i have a dell dimension 3000 and i dont know what an average temp is for pc's but its running around 33C (91F) is that good or bad?

i have one fan blowing out with my side panel off and a little 4 inch desk fan i got from walmart blowing in on the side. my pc room stays around 72F or so no dust either i blow my pc out every couple of weeks
 

A:average temp for a pc?

What temp is that case or CPU? If case then what's the CPU temp? Your CPU temp is fine under 65C while under load (gaming, someother heavy processing workout, i.e Prime95). At idle it should be around 30-35C with air cooling and standard room temp. 65C is getting hot and I wouldn't want mine to get any hotter then that, in fact that's the upper safe limit. You really want it no hotter then mid 50's. (under load)
 

Read other 15 answers
RELEVANCY SCORE 36.8

Just was wondering what the average cpu temp is in game with a 3.0g p4.Mine is currently running between 40c-49c
 

A:average cpu temp in-game

I don't think it is anything to worry about at 49*C.

Hell my Ahtlon 3200+ hits 55.
 

Read other 1 answers
RELEVANCY SCORE 36.8

Hello, this might be a tough one but here is what i am trying to accomplish.

My goal is to show the price we bought item A, by month, over a long period of time. i want to show an accurate average price for each month and i figured weighted average would be an accurate way using qty bought and the price per unit. I have the data for qty bought and price per unit. I don't want to use the average because there is alot of outliers and it doesn't take into acccount how many we bought.

So my question, is there anyway to show weighted average per month, with a pivot table.
 

A:Weighted average in Pivot

you could set a custom formula in the pivot and
do a sum(price)/sum(qty)

http://www.mrexcel.com/archive/Pivot/10389.html
http://office.microsoft.com/en-us/e...ottable-or-pivotchart-report-HP005199482.aspx
http://www.mrexcel.com/archive/Pivot/index.html
 

Read other 1 answers
RELEVANCY SCORE 36.8

Im looking for a new graphics card for my old pc:

Athlon 2500+
1 gig of ram
Quadro FX 2000 (very old 128mb card)

Now i know its really old, but it seem to hold out plying alot of new games, the only thing that lets it down is the graphics card when i use system requirements lab.

So im looking for a cheap 256mb card with all the needed features, nothing special, just enough to run a few new games like Company of Heroes. Anyone got anything to recommend?

I had a look at these on play.com

http://www.play.com/PC/PCs/4-/33488...S-256MB-DDR2-PCI-E-Graphics-Card/Product.html

http://www.play.com/PC/PCs/-/668/87...P-Graphics-Card/Product.html?searchtype=genre

http://www.play.com/PC/PCs/-/668/87...6-Graphics-Card/Product.html?searchtype=genre

Which of these is the best? ^

Something around that price, a VERY cheap card i know, prehaps about 40-50 if these are useless.

What you think?
 

A:Looking for a new average graphics card (UK)

well the nvidia 6600 is a good card although on play it 65...of your choice the 7300 is probably the best
 

Read other 1 answers
RELEVANCY SCORE 36.8

Chassis fan? Power fan? CPU fan?
 

A:Whats the average RPM of fans?

Read other 9 answers
RELEVANCY SCORE 36.8

Hi,
I have replaced my motherboard twice and apparently
need another one. All in 6 years. My computer store says this is about average. mmmmm, has anyone lost this many
motherboards??? the possible need of another one surrounds
the following symptoms: CD rom pops open on it's own
(occassionally), I will have 2-3 IE browsers open and the
2nd or 3rd one will occassionally lock up, inabilty to
start windows because of keyboard error(tech support says if it is the port it is made into the motherboard, thus new motherboard), a couple web pages have a portion of the text on that page all scrambled(small boxes) while the rest of the page is normal. One of my friends thinks I'm somehow causing these parts, etc to go bad because of computer illiteracy.
All, I do is e-mail and surf the web, save/send files, simple things because I am not elaborate computer user.
thanks for you input.
nick gill
NAEEM
 

A:average turnover of motherboards

i dont know what kind of system you are running but it sounds like you just outgrow them

as far as motherboards i work on some 100mhz machines that still run fine

your problems could range from anything to hardware or software

need to know more symptons of specific things

as far as web pages could just need cleaning

right click the start at bottom
left click explorer
find the temp and temp internet files and delete them all

then scandisk and defrag
you may have to disable screen savers and virus scan
click start
go to programs, accessories, system tools, scandisk
after that is finished go to
programs, accessories, system tools, disk defragmentor

when it finishes run system a little while then post any problems you are having

someone will help
 

Read other 3 answers
RELEVANCY SCORE 36.8

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
RELEVANCY SCORE 36.8

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
RELEVANCY SCORE 36.8

ok so here are my specs

AMD Athlon X2 5000+ 2.61GHz Duel Core
Sapphire ATI Radeon HD 5670
4GB of ram installed but vista says 3.2? (could this affect my games)
Corsair GS600w PSU
windows vista 32bit OS (im capable of 64bit)

now i have a dell dimension e521 and i feel the processor is letting me down i do not have money to upgrade it and when i overclock it fails on me (because of dell) but.. look at these people's specifications (below)and the games they can play i don't understand why i cant play!! i clean my computers registry and that with Advanced System Care Pro

http://www.youtube.com/watch?v=yy_o0-0VJXg (ultra settings !? )
http://www.youtube.com/watch?v=3q23I9M5Y-4 (medium to high!!?)
http://www.youtube.com/watch?v=FPC6huBdy74&feature=related (all maxed out)

What can i do to speed it up i can get new software and OS but i cant buy components (but you can still suggest some) i just really would like to be able to play games like battlefield 3 on medium settings, infact if i could play all games at a medium setting i would be soo gratefull

if you look on youtube there are people running nfs hot pursuit on max with the same specs as me or worse i just want to be able to do that please help

Im playing saints row 2
 

A:Average Specs LAG On Low End Games!?

The reason windows says you have 3.2GB of ram when you have 4GB is because you have the 32-bit Version of windows. Anything between 3 - 3.5GB it will cap on 32-Bit windows. The other RAM will not be used correctly.

Well registary cleaners are not good for any computer system and do more damage then good, they mess with windows files and needed registary files.

My computer specs in some ways are higher than yours like my i7 CPU then yours currently and I can only play battlefield 3 on Low setting and at 1280 x 768 resolution.

Make sure you have the latest grahpic card drivers installed. Check this website HERE search for a game you want to run and it will tell you if you can.
 

Read other 1 answers
RELEVANCY SCORE 36.8

just curious, what is the average processing speed of desktop computers?

HP media center pc m7640n
windows xp media center edition
2.6 GHz processor speed
 

Read other answers
RELEVANCY SCORE 36.8

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.
BJD
Ann Arbor, MI
 

A:Excel: Running Average?

Read other 7 answers
RELEVANCY SCORE 36.8

Something is wrong with my registry. I can't start an EXE file. Sometimes it says that I may not have the appropriate permissions, but after using several different versions winXP_reg_fix.reg it now tries to get winzip to open it (doesn't work). I've also tried manually adding it as an application in the file type list of the windows explorer tools, even though there's no 'restore' button.
 

A:not your average EXE registry problem.

Read other 10 answers
RELEVANCY SCORE 36.8

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 36.8

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
 

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 36.8

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 36.8

Hi, I'm using Excel 2003, and I've built a macro to do various things, one of them to add subtotals based on the change in data. I simply used the function under Data>subtotals to do the summing but I need one column to sum and then divide by the column next to it in order to give a weighted average.

I do not know VBA, but is there an easy way to do this?

Thanks!
 

A:Macro Weighted Average

Hi there,

Do you have a sample of your data? And can you please post your code? If the data is not your data, please make sure the structure is equivalent. But yes, to answer your question, there is a way to do it, and it should be fairly easy.
 

Read other 3 answers
RELEVANCY SCORE 36.8

Hello,

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).
Thanks,
Ataraxiste
 

A:Difficult average on excel

Read other 16 answers