Productivity Tools

• Excel
• Assigning a value based on how often that entry occurs
• SumIf across multiple worksheets
• Things learnt from Cheat Sheets

Excel

Assigning a value based on how often that entry occurs

We are needing the Fee column to be auto populated as follows i.e. the First child in the family gets charged Fee1, 2nd Fee2 etc up until Fee5 (Which is the lowest fee possible). What formula can I use to create this?

https://techcommunity.microsoft.com/t5/excel/calculating-values-based-on-position-in-family/m-p/3599505#M158860

Example: Annual Invoicing Workings(families).xlsx

SumIf across multiple worksheets

How to SUMIF across multiple worksheet: sum-if-multiple-sheets.xlsx

Things learnt from Cheat Sheets

See examples here: Cheatsheets.xlsx