1

I have tried both of these in Google Spreadsheets and continue to get circular dependency errors. I am trying to show blank when the result is 0. New values are entered daily and want to have the average formula run down the entire column so I don't have to drag the previous day's box down to copy the info.

=IF(C19="","",sum(C14:C18))

=IF(C19="0","",sum(C14:C18))
3
  • What cell are you putting the formula into? Oct 8, 2014 at 16:29
  • Need a running average of cells that are not in a range. Originally thought if the formula for the cell resulted in blank instead of 0 that it would not be included in the average. Now trying the averageif function but get error re: wrong number of arguments. Here is link to spreadsheet. See row C4, E4, G4 for various attempts. docs.google.com/spreadsheets/d/… Oct 9, 2014 at 0:31
  • That link will not let you view formulas. Here is another link: docs.google.com/spreadsheets/d/… Oct 9, 2014 at 0:34

1 Answer 1

2
=average(C:C)  

should average the whole of ColumnC's numeric values, without difficulties over text or spaces in that column, while responsive to changes in ColumnC entries - with the proviso that the formula should not be in ColumnC.

1
  • Need a running average of cells that are not in a range. Originally thought if the formula for the cell resulted in blank instead of 0 that it would not be included in the average. Now trying the averageif function but get error re: wrong number of arguments. Here is link to spreadsheet. See row C4, E4, G4 for various attempts. docs.google.com/spreadsheets/d/… Oct 9, 2014 at 2:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.