View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DK Liner DK Liner is offline
external usenet poster
 
Posts: 5
Default Sum = B3 if B1= Marketing

C3 = either Member Services, Education, Marketing or Admin.
D3 = Qty Ordered (ea order)
E3 = Unit Price (per order)
F3 = Total (per order)

I need to have a colum for each dept. (Member Srvs, Education, etc) for each
day with a total for each dept.
so
Education Total is G3
Member Services is H3

Is it countif?......Or can you think of an easier format.

Thank you in advance.