Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 2
Average formula Counting zero's How do I get just the numers counted.

Spreadsheet is created for a layover from other sources, therefore,
zeros will be present when data is laid on top of master spreadsheet.
Also, want to show no values by using a "-" when no numbers present
for easy recognition. Current formula is =IF(SUM(D9:GU9)=0,"-",
(AVERAGE(D9:GU9))) but if two numbers and a zero are present it
averages by three. Can anyone HELP?????

#2
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 273
Average formula Counting zero's How do I get just the numers count

what if you used "" instead of "-"? this would display nothing in the cell

" wrote:

Spreadsheet is created for a layover from other sources, therefore,
zeros will be present when data is laid on top of master spreadsheet.
Also, want to show no values by using a "-" when no numbers present
for easy recognition. Current formula is =IF(SUM(D9:GU9)=0,"-",
(AVERAGE(D9:GU9))) but if two numbers and a zero are present it
averages by three. Can anyone HELP?????

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Discussion (Misc queries) 2 March 2nd 07 04:11 AM Alex Excel Worksheet Functions 5 March 28th 06 07:27 PM JR Excel Worksheet Functions 2 March 16th 06 04:39 PM JR Excel Worksheet Functions 1 March 16th 06 03:46 PM raeleanne Excel Worksheet Functions 8 July 22nd 05 02:48 PM

All times are GMT +1. The time now is 01:20 AM.