View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Turi Turi is offline
external usenet poster
 
Posts: 2
Default sumproduct and average functions

I have a list of accts with their # of employees and their annual revenues.
I want to take the average of their annual revenue if they have between 50 &
100 employees. I figured I needed to use the average and sumproduct
functions, but I'm not sure how.

Please help, thanks
--
Turi