Need Some Excel Help (I Buggered Up The Matrix)

[DJLO]

Folks

I am no excel wizard. Jacks561 started the matrix and handed it off to me. I noticed it has stopped counting the amount of new releases on the 1st page.

It is calculating the total GB and average game size but the count of good and bad games has ****ed up somehow. I have an old dump but when i load it into excel, it is showing some error in the formula. Would someone mind taking a stab and let me know what i need to do to fix it.

It may have happened on an edit i did days back and moved the boxes around to make some space.

I've attached the last dump i have (that needs fixing)

Thanks !

EDIT: Use the new matrix.xls sheet i have attached. The problem seems to have happened when i removed the column for DVDR the other day

[Xeauron]

Let's have a look then.

EDIT: The one I looked at (Matrix 2) looks fine for both average and total sum. Am I looking at the wrong place here?

[Steveola]

If you have been using cut & paste on the cells, you probably messed up some formulae.

***Had a quick look and the formulae are calculating from row 5 instead of row 6.
Apart from that it looks ok.

[DJLO]

I have attached a new file with the formulas in it but no %

The ones with the % seems to have lost the formula

Any help would be really appreciated

[DJLO]

Let's have a look then.

EDIT: The one I looked at (Matrix 2) looks fine for both average and total sum. Am I looking at the wrong place here?

The sum is ok

I cannot get it to count the amount of working and non working internal and external game anymore. I moved some stuff around the other day and that broke it

[DJLO]

Work Problem Fail %
Internal 286 8 26 89.38%
External 213 14 73 71%

This is what broke

If anyone has an old dump of the spreadsheet that is calculating this properly, please attach it

[Xeauron]

Crap, sorry I'm away from my keyboard for a few mins, I'll have another look as soon as!

[Steveola]

Ahhh, I see.

Just put the following formaula in for that calculation:

=(D2/((D2+E2)+F2))
=(D3/((D3+E3)+F3))

Top one is internal
bottom one is external

Format cells as Percentage to 2 decimal places.

[stock2255]

Steveola did it right. Uploaded that fix as an attachment if ya like.

[DJLO]

Ahhh, I see.

Just put the following formaula in for that calculation:

=(D2/((D2+E2)+F2))
=(D3/((D3+E3)+F3))

Top one is internal
bottom one is external

Format cells as Percentage to 2 decimal places.

There were 6 separate formulas. For example internal working was :

=COUNTIF(E5:E$65536,"Y")

What you've posted, will that work for all of them? As you can tell i am really not good with Excel.