Spreadsheet: 763163d1642013724-combining-different-if-fuctions-based-on-multiple-criterias-in-different-tabs-example-pl-act-bud-ly-and-departments
Sheet: Department 1

 | Department 1
 |  | Actuals 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual 2020 (last year)
 |  | January | February | March | April | May | June | July | August | September | October | November | December | Total 2021 |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | Total 2021 |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | Total 2021
Category | Revenue A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category | Revenue A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category | Revenue A
Revenue 1 | Account 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | Revenue 1 | Account 1 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 50 |  |  | Revenue 1 | Account 1 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Revenue 1 | Account 2 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Revenue 1 | Account 2 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |  |  | Revenue 1 | Account 2 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Revenue 1 | Account 3 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Revenue 1 | Account 3 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |  |  | Revenue 1 | Account 3 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Revenue 1 | Account 4 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Revenue 1 | Account 4 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |  |  | Revenue 1 | Account 4 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Revenue 1 | Account 5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Revenue 1 | Account 5 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |  |  | Revenue 1 | Account 5 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 10
 | Revenue B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue B
Revenue 2 | Account 6 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  | Revenue 2 | Account 6 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 |  |  | Revenue 2 | Account 6 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Revenue 2 | Account 7 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  | Revenue 2 | Account 7 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 |  |  | Revenue 2 | Account 7 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 80
Revenue 1 | Account 8 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  | Revenue 1 | Account 8 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 |  |  | Revenue 1 | Account 8 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Revenue 2 | Account 9 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  | Revenue 2 | Account 9 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 |  |  | Revenue 2 | Account 9 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Revenue 2 | Account 10 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  | Revenue 2 | Account 10 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 |  |  | Revenue 2 | Account 10 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
 | Total revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total revenue
 | Cost A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost A
Cost 1 | Account 11 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | Cost 1 | Account 11 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 11 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Cost 1 | Account 12 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | Cost 1 | Account 12 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 12 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Cost 1 | Account 13 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | Cost 1 | Account 13 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 50 |  |  | Cost 1 | Account 13 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Cost 2 | Account 14 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | Cost 2 | Account 14 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 14 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Cost 2 | Account 15 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  | Cost 2 | Account 15 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 15 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 | Cost B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost B
Cost 2 | Account 16 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 16 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 16 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75
Cost 2 | Account 17 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 17 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 2 | Account 17 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75
Cost 1 | Account 18 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 18 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 70 |  |  | Cost 1 | Account 18 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 90
Cost 1 | Account 19 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 19 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 19 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75
Cost 1 | Account 20 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 20 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  | Cost 1 | Account 20 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75
 | Total costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total costs
 | Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profit