View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Conditional Average...

Yes, you can use subtotals as suggested by Michael
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Sandre" wrote:

Hi,

I am trying to calculate the average number of days it took my staff to
complete various customer requests. I have the network days formula already
done, but now I am trying to figure the average number of workdays for each
type of request. For example, what was the average number of days it took to
complete an address change, or cancel their account? the type of request is
in column B, and the network days are figured in column H.

I have Excel 2003, and can't seem to figure out how make it work so that it
separates each type of request and creates the average number of networkdays.

Thank you in advance :)