Comparing more than two
You could use the SUMPRODUCT function. Let's say Date is in Column A, Name
is in Column B, and Amount is in Column C.
=SUMPRODUCT(--(MONTH(A1:A100)=9),--(B1:B100="Smith"),C1:C100)
This should total all of Smith's sales for the month of September. If your
Date column spans multiple years, then you'd need to account for the year as
well.
HTH
Elkar
"Vern" wrote:
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.
|