Cell range: E8:G8,

I need to take the average, but only if there are values in the cell, so that excel doesn't give the #VALUE! count error

I have it set up like this

=IF("*missing*", AVERAGE(E8:G8), "")

The *missing* needs to be filled in, any help is appreciated!!

 

if there are no values...it wont count it. just do =AVG(E8:G8)

 

but i dont think u need an IF statement just for that

 

There are no values currently, but the cells are defined as 'number' since they're linked to other worksheets with graphs. Because of this it's giving me the error in value message

 

COPY + PASTE SPECIAL VALUES .... then do your avg

 

when that happens to me, i just put in the raw data again, but that would be tedious for a large set of data.

dude, i dunno...i dont even really know what you're talking about...cant know unless i see the sheet.

 

ughh.....I wish I could put up a screen shot

 

ok, basically, I cant have zeroes in teh cells, since it would misrepresent data in other sheets. So, barring that, I need to have a way of taking the average in the summary cell only IF there is data in the criteria cells

 

ah i c. so what you're saying is that you cant even just leave the cell blank b/c it'll still count it as another "n" (b/c it's linked to other sheets), which will screw up the stats.

dude, sorry, but i dunno. i usually do my stats and graphs and such in a program other than excel that doesnt do things like that.

 

ya and none of the stuff i do really involves getting an avg ... and if it does the #'s are all down a column ..

 

Ok, cool, thanks for all you guys' help anyways, much appreciated!!

 

I GOT IT!!!!!!!!!!!!!!!!!!!!!!!1

=IF((SUM(E8:G8)>0), AVERAGE(E8:G8), "")

Persistence FTW!!!!!

 

haha! nice...it seems simple now...lol.