"&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. .">
• 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.