I'm not a power Excel user, but I'm constructing a pretty simple grading
platform for a friend who is a teacher.

I want to AVG a row of cells, and, I understand that when the cell contains
no information, the AVG function does not count it.

However, on the top level sheet, that row of cells picks their numeric
values from lower level sheets, so each cell has "other sheet location"
information there to start with. The AVG function then sees this as
information and counts that cell in the average, when it should not be.

I guess there should be a variable, or some script I should use that would
tell the AVG function only to count the cells that contain numeric values???

Any help with this would be EXTREMELY appreciated!!!

If you're using a formula to return a value from a different worksheet, you may
want to use something like:

=if(sheet1!a1="","",sheet1!a1)
or
=if(isna(vlookup(a2,sheet1!a:b,2,false)),"",
if(vlookup(a2,sheet1!a:b,2,false)=0,"",
vlookup(a2,sheet1!a:b,2,false)))

Then those strings ("") won't be included in your =average() function.

Mike612 wrote:

I'm not a power Excel user, but I'm constructing a pretty simple grading
platform for a friend who is a teacher.

I want to AVG a row of cells, and, I understand that when the cell contains
no information, the AVG function does not count it.

However, on the top level sheet, that row of cells picks their numeric
values from lower level sheets, so each cell has "other sheet location"
information there to start with. The AVG function then sees this as
information and counts that cell in the average, when it should not be.

I guess there should be a variable, or some script I should use that would
tell the AVG function only to count the cells that contain numeric values???

Any help with this would be EXTREMELY appreciated!!!

--

Dave Peterson