Thread: SUM Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SpottedOrange SpottedOrange is offline
external usenet poster
 
Posts: 2
Default 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)))