Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 15, 2013
user Stupac310 (http://productforums.google.com/forum/?zx=yx0vn6gx56ds#!mydiscussions/docs/4bICingQ4IQ)
Count using multiple criteria including date range
I have a list of items sold by various sales reps over a 24-month period. I have sales dates and in some cases cancellation dates. I would like to count the number of sales each particular rep had in each month. I would also like to count how many of those sales wound up as cancellations. (Browser: Chrome).
INPUT: Columns are (A) Item Sold; (B) Sales Rep; (C) Sales Date as xx/xx/xxxx; (D) Cancellation Date as xx/xx/xxxx.
item sold Jane 12/15/2012 06/10/2013
item sold Fred 01/04/2013 03/25/2013
item sold Jane 01/20/2013
DESIRED OUTPUT: Columns would be (A) Sales Rep; (B, C, etc.) Month-Year; (Sub1) Sales ; (Sub2) Cancellations.
Sales Cans Sales Cans
Fred 0 0 1 1
Jane 1 1 1 0
What formula do I put in these cells? Count/Filter formulas? Array formulas? Thanks for any insight.
Hey Yogi, thanks for picking up the thread... per your instructions...
Sample Spreadsheet: https://docs.