IF Question

[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!

 

[Bob Phillips]

=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

 

[mcouch]

Bob,

Thank you SO MUCH! I tried it and it worked like a charm!