| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
Try
=SUMPRODUCT(AVERAGE(INDIRECT({"D4","G4","J4","M4"} ))) If this post helps click Yes --------------- Jacob Skaria "dernspiker" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
This gives me a #div/0! reply....
"Jacob Skaria" wrote: Try =SUMPRODUCT(AVERAGE(INDIRECT({"D4","G4","J4","M4"} ))) If this post helps click Yes --------------- Jacob Skaria "dernspiker" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
=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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "dernspiker" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Hybrid Mode
