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)))
|