First of all I have to say I am an amateur at excel. Secondly my question regards google spreadsheets, but i think it should be the same functions.
I am trying to make a google spreadsheet with the attendances of basketball games. I am giving a link to the current one. The problem is that I want to make it produce results with as little input data as possible. I am using two sheets, one with the stats and one with the results (data goes into "results" and stats should be produced in "stats" sheets).
I want to put in the results in the second sheet and have stats produced in the first. This is no problem so far as I use vlookup (cell, sheet!A:1:A2, 4, false i.e.) giving the range etc (cells b7 and b8 include the formula as an example)
The problem is that when i use vlookup for example in column B of sheet 1 (stats) I get as expected many #N/As and subsequently in cell B31 (stats sheet) called "TOTAL" I also get a #N/A as it has a SUM function of the column.
Is there any way I can have it ignore the #N/A (and hide them) and produce a SUM result of the column, or do I have to put in the data manually in sheet "stats" also?
thanks in advance
link to the spreadsheet
https://spreadsheets.google.com/spr...GF0Yk55d3Q2Q2RsYy1BR2xVRU5OVWc&hl=en_US#gid=0
I am trying to make a google spreadsheet with the attendances of basketball games. I am giving a link to the current one. The problem is that I want to make it produce results with as little input data as possible. I am using two sheets, one with the stats and one with the results (data goes into "results" and stats should be produced in "stats" sheets).
I want to put in the results in the second sheet and have stats produced in the first. This is no problem so far as I use vlookup (cell, sheet!A:1:A2, 4, false i.e.) giving the range etc (cells b7 and b8 include the formula as an example)
The problem is that when i use vlookup for example in column B of sheet 1 (stats) I get as expected many #N/As and subsequently in cell B31 (stats sheet) called "TOTAL" I also get a #N/A as it has a SUM function of the column.
Is there any way I can have it ignore the #N/A (and hide them) and produce a SUM result of the column, or do I have to put in the data manually in sheet "stats" also?
thanks in advance
link to the spreadsheet
https://spreadsheets.google.com/spr...GF0Yk55d3Q2Q2RsYy1BR2xVRU5OVWc&hl=en_US#gid=0