SUMIF over criterias for column and rows
Posted on 2014-07-21
I have a table with, for example, names of sales staff in Column A. Column B, C, D.... represent calendar days and the sales that each staff made on a given calendar day.
I'd like to write a formula on a separate worksheet that calculates the sales when the user enters:
B1 (Sales Rep Name): Jane Doe
B2 (Start Date): 01/01/2014
B3 (End Date): 01/15/2014
Output on cell C1 should be Jane Doe's sales from 01/01/2014 - 01/15/2014