I have a data entry worksheet called 'Entry', and a worksheet that calculatates totals called 'Total', within a workbook. Using the data in the 'Entry' tab, I want to Average all the items in Column A with the exception of the header and put it into cell A1 on the 'Total' tab. I DO want the Average to calculate any zero's, but I do not want it to consider blanks to be zeros. Please help! Thanks!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Average all items in a column w/ a header, & do not Average blank spaces as 'zero's.
- Thread starter amb
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Did you try...
=AVERAGE(Entry!A:A)
which should work?
=AVERAGE(Entry!A:A)
which should work?
Upvote
0
Similar threads
- Question
- Solved
