Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Formula
Hello All,
I have a worksheet calculating results from another sheet in the book but I want it to exclude N/A Values from the calculation. This is what I have, can you tell me what to add? Thanks? =SUM((Supervisor=$A$3)*((Training=9))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Formula
You may have intended to use SUMPRODUCT, rather than SUM.
You may also wish to use the ISNA function. -- David Biddulph "SpottedOrange" wrote in message ... Hello All, I have a worksheet calculating results from another sheet in the book but I want it to exclude N/A Values from the calculation. This is what I have, can you tell me what to add? Thanks? =SUM((Supervisor=$A$3)*((Training=9))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Formula
Hey David,
The SUMPRODUCT wont work because it is assigning it as 0 which will result in inaccurate data. The ISNA Function is it going to not count the N/A as i want it and if so how would I add it to the formula listed? "David Biddulph" wrote: You may have intended to use SUMPRODUCT, rather than SUM. You may also wish to use the ISNA function. -- David Biddulph "SpottedOrange" wrote in message ... Hello All, I have a worksheet calculating results from another sheet in the book but I want it to exclude N/A Values from the calculation. This is what I have, can you tell me what to add? Thanks? =SUM((Supervisor=$A$3)*((Training=9))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|