Test DATA question

[Brown]

Good Morning,
I am working with some test DATA, i am a teacher, and i have three columns
A1 B1 C1
Increase (the difference between the scores) New Scores Old Scores

In the increase column i am getting the difference of the two other cells in that row
i have the average of all three columns at the bottom of the page

In the columns there are some empty cells, so my question is what formula do i use so the empty cells are not calculated?

i hope this makes sense
Thank for the help, you guys have never steered me wrong

 

[tyija1995]

=AVERAGE will work with blank cells,

Say in column C (old scores(?)) you have
4
5
*BLANK*
3
1
=AVERAGE(C2:C6) returns 3.25, which is indeed the average of 4,5,3 & 1

 

[Fluff]

If the cells are empty then you can use AVERAGE
If they have a 0 that you don't want to include then use AVERAGEIF

 

[Brown]

thanks for the advice.
my problem seems to be this now, my rows are set up like this a2 = difference from b2 and c2

a2 = -400 b2 = "blank" c2 = 400
when i dont have the new score cell b2 i get a negative number in a2. How do i write the formula that will not count the blank in the row of cells? this is throwing off my average at the bottom of my column

Thanks Brown

 

[tyija1995]

Assuming you only want to look at column B (new scores) try this:

=IF(ISBLANK(B2),"",B2-C2)

If you want to consider column B & C use:

=IF(OR(ISBLANK(B2),ISBLANK(C2)),"",B2-C2)

 

[Fluff]

Or
=if(b2="","",b2-c2)