Hi All,
I work for a non profit organization and helping them setup a budget workbook and getting totals for . Any help would be appreciated. I'm trying to sum of the totals based on dates that have a criteria which is the Employee ID. My goal is to get a formula for the total of Employee #20012 for the date ranges of 01/01/18 through 3/01/18 in program Orchard. Thanks again and please let me know if you need any clarifications. The answer in the cell should be $1,321
<tbody>
</tbody>
I work for a non profit organization and helping them setup a budget workbook and getting totals for . Any help would be appreciated. I'm trying to sum of the totals based on dates that have a criteria which is the Employee ID. My goal is to get a formula for the total of Employee #20012 for the date ranges of 01/01/18 through 3/01/18 in program Orchard. Thanks again and please let me know if you need any clarifications. The answer in the cell should be $1,321
A | B | C | D | E | E | F | |||
Employee ID | 01/01/18 | 2/01/18 | 3/01/18 | 4/01/18 | Program | Total | |||
20012 | $543 | $233 | $545 | $432 | Orchard | ???? | |||
20012 | $452 | $362 | $263 | $556 | YS | ||||
20034 | $112 | $223 | $332 | $123 | Lay |
<tbody>
</tbody>