Hi Community Members...
In C5 I want to average the only negative numbers
if its entered in B9:B29. If there is no negative number C5 should be blank or "No data" message.
I used =AVERAGE(IF(B9:B29<0,B9:B29," ")), but it returns a #DIV/0! error.
I have looked at Excel Help but could not work....
All help much appreciated and I thank all for their
help and time with my inquiry.
Best Regards.
Bookmarks