Oh my GOSH!!! Thats it!!! Thank you sooooo much... I have been trying to
find this formula for quite a while.

THANKS!

"T. Valko" wrote:

They may or may not cotain N/A

Is that the TEXT string N/A or the Excel error value #N/A?

If it's the text string N/A try this:

=IF(D4&G4&J4&M4="NANANANA","NA",IF(COUNT(D4,G4,J4, M4),AVERAGE(D4,G4,J4,M4),""))

--
Biff
Microsoft Excel MVP


"dernspiker" wrote in message
...
In Cell N4 I need to average:

D4 G4 J4 M4

They may or may not cotain N/A

If they ALL contain N/A I need it to return and N/A

I will have more questions later today.

Thank you,
Dana