SUM Formula

S

SpottedOrange

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

David Biddulph

You may have intended to use SUMPRODUCT, rather than SUM.
You may also wish to use the ISNA function.
 
S

SpottedOrange

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?
 
Top