View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
barts barts is offline
external usenet poster
 
Posts: 1
Default Help with Lookup formula

I have a spreadsheet where I would like to quantify the amount of
entries pertaining the to the following:

Column A = Supervisors Names (A, B, C, D, E)
Column D = Status (Awaiting Contracts, In Progress, Complete)
Column E = Contract Value ($)

I would like to create a list that can extract from the above columns
the number of jobs each supervisor has at each status and the $ value
(expressed as a total) for each status.

If anyone can offer assistance on this subject, i would be very
thankful.

Regards,


Alan