Average Sum needs blank if no info
 

OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks

Average Sum needs blank if no info
 

=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))
--
HTH...

Jim Thomlinson


" wrote:

OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks

Average Sum needs blank if no info
 

On Jul 24, 9:25*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))
--
HTH...

Jim Thomlinson
Gave me an error. Err:508. if that helps

" wrote:
OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks

Average Sum needs blank if no info
 

I bet Jim uses a comma for his list separator.

And he was being very nice when he used semi-colons in his suggested
formula--but he missed a couple of commas (fingers KNOW what to type <vbg).

Try changing those 2 commas to semicolons.

(although I'm not sure what that 508 error is...)



" wrote:

On Jul 24, 9:25 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))
--
HTH...

Jim Thomlinson
Gave me an error. Err:508. if that helps

" wrote:
OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks

--

Dave Peterson

Average Sum needs blank if no info
 

how about
=IF(ISERROR(AVERAGEA(B3,D3,F3)),"",AVERAGEA(B3,D3, F3))
and with semicolons:
=IF(ISERROR(AVERAGEA(B3;D3;F3)),"",AVERAGEA(B3;D3; F3))

;429151 Wrote:
OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119239

Average Sum needs blank if no info
 

Got the answer right he

=IF(B3=0;0;AVERAGEA(B3;E3;H3))


Thanks guys!