View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vern Vern is offline
external usenet poster
 
Posts: 7
Default Comparing more than two

I have a spreadsheet that tracks Date, Salesman and Sale Amount in separate
columns with information over a year. How do I do an analysis of monthly
sales for each salesman individually.
I tried sumif(and but cannot seem to make it work? I am sure there is a way.