Thread
:
SUM Formula
View Single Post
#
1
Posted to microsoft.public.excel.misc
SpottedOrange
external usenet poster
Posts: 2
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)))
Reply With Quote
SpottedOrange
View Public Profile
Find all posts by SpottedOrange