Hi, I need help with getting an excel formula that can do the following:
COUNTIFS(A:A, All cells that start with RMA,C:C,"C",B:B,DATE from JAN 1, 2015 to JAN 31, 2015)
COUNTIFS(A:A, All cells that start with RMA,C:C,"C",B:B,DATE from FEB 1, 2015 to FEB 28, 2015)
and so on.
I have attached the spreadsheet for better clarity. Data is located on Tab: Sheet1
Table with formulas on tab: Sheet2
Thank you for the help on this.
Bookmarks