Timwhitcher
New Member
- Joined
- Aug 13, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I am trying to make a resource tracker with a front sheet and a data sheet. we can only order in boxes of 25 so spare stock builds up
The data sheet 2 looks similar to this with customer details that can be ignored
i need the front page (Sheet 1) to look like this
how do i filter by the installer name to get the totals i need?
The data sheet 2 looks similar to this with customer details that can be ignored
Installer Name | amount ordered | amount needed |
Dave | 25 | 20 |
Bob | 50 | 36 |
Jane | 75 | 67 |
Bob | 25 | 12 |
Dave | Bob | Jane | |
Total amount ordered | on sheet 2 if column 1 = Dave add values in column 2 | ||
Total amount needed | on sheet 2 if column 1 = Dave add values in column 3 | ||
Spare stock | =SUM(B2-B3) |