Tech Support Forum banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
I am trying to create a formula to calculate the overall average of another column full of data. Now as I add new data, the formula will also update the new averaged values, however it displays that total all the way down the rest of the column. I need this formula to ignore null values as well as zero values, unless the cell has been updated. Here is the current formula that I am using:

=AVERAGE(IF(C$5:C5<>0, C$5:C5,""))

Can someone please offer some assistance here. Thank you in advance.
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top