• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

dragging formulas so they refer to correct cells

M

misia81

New Member
Hello,


I have this formula below, which averages 10 data points from a different spreadsheet onto this new spreadsheet and if the cells are empty fills them with the average. However, when I drag the formula across to other columns, it uses this same average calculated from the previous 10 data points. Any tips on how to fix this formula? Also, any tips on how to add an error statement so that if the calculations make errors (due to missing data) to leave the cells blanks? I've messed this up several times already and would appreciate any help.


=IF('HMIS Raw - DH, CRH, HC'!C2<>"",'HMIS Raw - DH, CRH, HC'!C2,AVERAGE('HMIS Raw - DH, CRH, HC'!$C$2:$C$13))


Thanks!
 
Hello,


Error statements:


2003 =IF(ISERROR(STATEMENT),"ERROR MESSAGE",STATEMENT)

2007 =IFERROR(STATEMENT,"ERROR MESSAGE")


The $$$ are limiting your average to c2:c13.


Thanks
 
You must log in or register to reply here.
Back
Top