- Joined
- Aug 24, 2007

I'm making some charts that plot performance in games, and using rows to list what game, and column to list the FPS scores. At the bottom of each column, I've got a cell that says "=AVERAGE(C2:C23)" for example. Also, since I'm listing data for 2 different cards, I'm using "=(B2-C2)/C2" in cell D2 to show the % difference between the scores.

I've got all the basic info (list of games for example) in the first sheet, and each individual review site on its own sheet. I'm just copy/pasting the whole template from the first sheet into each new sheet and filling in the blanks. I'm having two problems, both pretty much the same. Both of those formulas I listed above work fine when there is data, but when there is not, they display a divide by zero error.

Is there a simple/stupid way to make the =AVERAGE function only average up the non-zero entries, and is there a way to make the B2-C2 thing also ignore =zero stuff?

Pic attached if that helps, and thanks

BTW, are there any 3D spreadsheets? I could have done this all on one sheet if so..

I've got all the basic info (list of games for example) in the first sheet, and each individual review site on its own sheet. I'm just copy/pasting the whole template from the first sheet into each new sheet and filling in the blanks. I'm having two problems, both pretty much the same. Both of those formulas I listed above work fine when there is data, but when there is not, they display a divide by zero error.

Is there a simple/stupid way to make the =AVERAGE function only average up the non-zero entries, and is there a way to make the B2-C2 thing also ignore =zero stuff?

Pic attached if that helps, and thanks

BTW, are there any 3D spreadsheets? I could have done this all on one sheet if so..