Need Help : Conditional Average IF cell is greater than 0

[Dustin]

I am trying to average the values in H4:H124 providing the number is greater than 0. Right now, my averages are really low because so many 0's are being included.

Please help me.

Also, is there anyway to keep 1264 from being displayed in a cell that counts the number of months past if the date field is blank? Here is the formula used:=DATEDIF(G4,TODAY(), "m")

Thank you for your help!

 

[Aladin Akyurek]

Re: Need Help : Conditional Average IF cell is greater than

I am trying to average the values in H4:H124 providing the number is greater than 0. Right now, my averages are really low because so many 0's are being included.

=SUMIF(H4:H124,">0")/MAX(1,COUNTIF(H4:H214,">0"))

for positive non-zero numbers.

Also, is there anyway to keep 1264 from being displayed in a cell that counts the number of months past if the date field is blank? Here is the formula used:=DATEDIF(G4,TODAY(), "m")

=IF(ISNUMBER(G4),DATEDIF(G4,TODAY(), "m"),"")