"&TODAY(),F9:F134) It is taking information from the following: Date Received....Date Invoiced (E)...Claim Life (F) 1 March............14 March .............. 13 1 March............6 March............... 5 1 Feb................14 March.............. 41 1 Jan................10 March.............68 So the formula is supposed to give me the average claim life of the above rows in bold text... (dates of 14 March in column E are using the formula =TODAY() so anything with today's date is excluded )... but the formula is calculating 0.6 instead of 36.5. Please note, claim life (column F) is also a formula =DATEDIF(D9,E9,"d") so I'm not sure if that has anything to do with it? Where am I going wrong? I have a similar formula that works fine but this one does not.... Any help would be hugely appreciated! Thank you. .">
Most valuable professional
  • Hot Topics

Excel AverageIf Function giving unexpected result

Hi All, I have the following formula: =AVERAGEIF(E9:E134,"<>"&TODAY(),F9:F134) It is taking information from the following: Date Received....Date Invoiced (E)...Claim Life (F) 1 March............14 March .............. 13 1 March............6 March............... 5 1 Feb................14 March.............. 41 1 Jan................10 March.............68 So the formula is supposed to give me the average claim life of the above rows in bold text... (dates of 14 March in column E are using the formula =TODAY() so anything with today's date is excluded )... but the formula is calculating 0.6 instead of 36.5. Please note, claim life (column F) is also a formula =DATEDIF(D9,E9,"d") so I'm not sure if that has anything to do with it? Where am I going wrong? I have a similar formula that works fine but this one does not.... Any help would be hugely appreciated! Thank you.

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 13, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel