Totaling formula help

[Sintheticxtac]

Alright guys, I have a running log that averages numbers. For example I have =SUM(B10+C10+D10). That gives me my sum in E10. I also have a column in F10 which I DO NOT want included into that some, HOWEVER, occasionally that column gets an entry on it's own, producing a SUM of 0.000 in the D column. How can I stop this from producing that SUM of 0.000? We have a few employees messing up their averages because they aren't considering that 0.000, so any help with this would be appreciated. Thanks in advance guys!

 

[AhoyNC]

So the issue is they enter the value in column F instead of D?
If so maybe something like this:

Excel Workbook
	B	C	D	E
10	12	25		Some Error Msg
Sheet

Or
[TABLE="width: 383"]
<colgroup><col width="383"></colgroup>[TR]
[TD="width: 383"]=IF(ISNUMBER(F10),"Your error msg.",SUM(B10:D10))[/TD]
[/TR]
[/TABLE]

 

[inactiveuserps07]

@Sintheticxtac, your post says that people are messing up their "average," but I only see a SUM(), not an AVERAGE(). It seems to me that, if you're trying to average those cells but not include a possible zero inclusion, you'd need this somewhere:

=AVERAGEIF(B10:D10,">0")