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

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

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