# Average all items in a column w/ a header, & do not Average blank spaces as 'zero's.

#### amb

##### New Member
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!!

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

##### MrExcel MVP
Did you try...

=AVERAGE(Entry!A:A)

which should work?

Replies
3
Views
658
Replies
2
Views
334
Replies
1
Views
247
Replies
1
Views
342
Replies
1
Views
560

1,191,348
Messages
5,986,142
Members
440,005
Latest member
tombamber

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back