Need a formula to average a range of cells but only if there are numbers so I dont get a zero.
=AVERAGE(IF(E8:N8,E8:N8)) this is what I'v tried but I just get #VALUE!
Thanx![]()
Need a formula to average a range of cells but only if there are numbers so I dont get a zero.
=AVERAGE(IF(E8:N8,E8:N8)) this is what I'v tried but I just get #VALUE!
Thanx![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks