IF Question

  • Thread starter Thread starter mcouch
  • Start date Start date
M

mcouch

New to Excel and am having trouble with a formula - I believe it would be an
=IF?

If cells F4 thru F11 have "N/A" in each then cell F12 (the total/Average)
cell should say "N/A"; if a number is entered into any of those cells (F4
thru F11) I would like to Average those numbers in F12.

Example:
F4 N/A
F5 N/A...
F11 N/A
F12 N/A (the total/Average cell)

F4 84.00%
F5 N/A
F6 94.00%
F7 N/A...
F12 89.00% (the total/Average cell)


Any help is greatly appreciated!
 
=IF(NOT(COUNTIF(F4:F11,"<>N/A")),"N/A",AVERAGE(IF(F4:F11<>"N/A",F4:F11)))

this is an array formula, so commit with Ctrl-Shift-enter
 
Back
Top