tacokisses
New Member
- Joined
- Oct 26, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Link below.
Looking to figure out how to do a sumproduct (if that is the right formula) for a number of data onto one spreadshet. Looking on "tips Payroll" for a named individual to find the sum of all tips in "tips calc week one" under their name in each department. For instance, in "tips payroll" i Want name "Mark (eg) to give me his total tips from Bar, Cafe and Bottleshop departments from the worksheet "Tips Calc Week One" from the
Total column. Is this possible? I have added Test to test it but I cannot find a formula that works. Again, link below to download and check out the spreadsheet in excel. Or see it in Google Sheets. let me know. Thanks.
Tips Spreadsheet
Tips Spreadsheet
Looking to figure out how to do a sumproduct (if that is the right formula) for a number of data onto one spreadshet. Looking on "tips Payroll" for a named individual to find the sum of all tips in "tips calc week one" under their name in each department. For instance, in "tips payroll" i Want name "Mark (eg) to give me his total tips from Bar, Cafe and Bottleshop departments from the worksheet "Tips Calc Week One" from the
Total column. Is this possible? I have added Test to test it but I cannot find a formula that works. Again, link below to download and check out the spreadsheet in excel. Or see it in Google Sheets. let me know. Thanks.
Tips Spreadsheet
Tips Spreadsheet