Thread: DAVERAGE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AAS AAS is offline
external usenet poster
 
Posts: 24
Default DAVERAGE

trying to average a column of numbers but only the numbers which are memco
from column B and SMF from column C

I was told DAVERAGE is the way to go but I can't get the formula right

Production Calendar (sheet 1)

john doe Memco SMF $20
joe garcia AAS SMH $13
jessie nelson Memco SMF $10
david toms Memco SMM $ 9


Wage Summary (sheet 2)

average wage of a Memco, SMF employee = ____


The answer would be $15