Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

average with some empty cells 1

Status
Not open for further replies.
workshop

workshop

Technical User
Nov 9, 2001
55
0
0
US
how do I do average in column that has data but exclude the cell that don't have data?

Thanks in advance
 
Sort by date Sort by votes
Hi,

As long as the cells are empty and do not contain a zero, the AVERAGE function will only use values.

Skip,
[sub]
[glasses] [red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Question
Count range overlap cells
Replies
3
Views
132
N1GHTEYES
N1GHTEYES
cneill
  • Locked
  • Question
Hi, I need some help with Pre an
Replies
7
Views
106
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
122
SkipVought
S
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
93
SkipVought
S
caykamanj1966
  • Locked
  • Question
Place a hyperlink on multiple cells with text in Microsoft Excel
Replies
9
Views
144
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top