Good deal!

--
Biff
Microsoft Excel MVP


"dernspiker" wrote in message
...
I Caught that, and fixed it already...



"T. Valko" wrote:

=IF(D4&G4&J4&M4="NANANANA"

Ooops!

I forgot to include the slash in the N/A string:

Change to:

=IF(D4&G4&J4&M4="N/AN/AN/AN/A"

Or:

=IF(D4&G4&J4&M4=REPT("N/A",4)


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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