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))
Improve this question
3
  • What cell are you putting the formula into?
    – MaryC.fromNZ
    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/…
    – user3927846
    Oct 9, 2014 at 0:31
  • That link will not let you view formulas. Here is another link: docs.google.com/spreadsheets/d/…
    – user3927846
    Oct 9, 2014 at 0:34

1 Answer 1

Reset to default
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.

Improve this answer
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/…
    – user3927846
    Oct 9, 2014 at 2:03

Your Answer

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

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