Cjhicks2708
New Member
- Joined
- Jul 13, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi, I am looking to calculate total salary month on month, but need to also consider if the person is still employed. What i am looking to do is present a month on month total spent on salaries. I have the hire date and the employment status. I am not sure if i should be using a countif here?
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Employment Status | Hire Date | Probabtion Date | End date | Pay rate | Base Currency | Paid per | Pay type | Salary £ | ||
2 | Terminated | 24/02/2020 | 23/07/2020 | 27/11/2020 | £ 43,400.00 | GBP | Year | Salary | £ 43,400.00 | ||
3 | Full-Time | 14/11/2019 | 12/04/2020 | £ 52,500.00 | GBP | Year | Salary | £ 52,500.00 | |||
4 | Full-Time | 07/09/2020 | 04/02/2021 | £ 49,000.00 | GBP | Year | Salary | £ 49,000.00 | |||
5 | Terminated | 29/10/2018 | 28/03/2019 | 10/01/2020 | $ 75,478.90 | USD | Year | Salary | £ 54,344.81 | ||
6 | Terminated | 01/07/2019 | 28/11/2019 | 08/07/2020 | £ 63,000.00 | GBP | Year | Salary | £ 63,000.00 | ||
7 | Terminated | 06/01/2020 | 04/06/2020 | 06/10/2020 | £ 35,000.00 | GBP | Year | Salary | £ 35,000.00 | ||
8 | Terminated | 02/08/2017 | 30/12/2017 | $ 61,600.00 | USD | Year | Salary | £ 44,352.00 | |||
9 | Full-Time | 29/04/2019 | 26/09/2019 | £ 28,000.00 | GBP | Year | Salary | £ 28,000.00 | |||
10 | Full-Time | 11/09/2017 | 08/02/2018 | $ 120,615.60 | USD | Year | Salary | £ 86,843.23 | |||
11 | Terminated | 30/03/2020 | 27/08/2020 | 30/04/2021 | £ 25,900.00 | GBP | Year | Salary | £ 25,900.00 | ||
12 | Full-Time | 10/06/2019 | 07/11/2019 | £ 38,500.00 | GBP | Year | Salary | £ 38,500.00 | |||
13 | Terminated | 24/07/2017 | 21/12/2017 | 13/01/2020 | $ 105,538.30 | USD | Year | Salary | £ 75,987.58 | ||
14 | Terminated | 02/12/2019 | 30/04/2020 | 15/07/2020 | £ 42,000.00 | GBP | Year | Salary | £ 42,000.00 | ||
15 | Full-Time | 18/02/2019 | 18/07/2019 | £ 37,100.00 | GBP | Year | Salary | £ 37,100.00 | |||
16 | Full-Time | 21/09/2020 | 18/02/2021 | £ 21,000.00 | GBP | Year | Salary | £ 21,000.00 | |||
17 | Full-Time | 28/09/2020 | 25/02/2021 | £ 70,000.00 | GBP | Year | Salary | £ 70,000.00 | |||
18 | Full-Time | 25/11/2019 | 23/04/2020 | £ 47,600.00 | GBP | Year | Salary | £ 47,600.00 | |||
19 | Full-Time | 13/01/2020 | 11/06/2020 | £ 21,000.00 | GBP | Year | Salary | £ 21,000.00 | |||
20 | Terminated | 27/04/2020 | 24/09/2020 | 31/03/2021 | £ 33,600.00 | GBP | Year | Salary | £ 33,600.00 | ||
21 | Full-Time | 15/07/2019 | 12/12/2019 | £ 24,500.00 | GBP | Year | Salary | £ 24,500.00 | |||
22 | Full-Time | 28/09/2020 | 25/02/2021 | £ 59,500.00 | GBP | Year | Salary | £ 59,500.00 | |||
23 | Full-Time | 13/01/2020 | 11/06/2020 | € 88,200.00 | EUR | Year | Salary | £ 74,970.00 | |||
24 | Terminated | 16/09/2019 | 13/02/2020 | 14/08/2020 | £ 53,900.00 | GBP | Year | Salary | £ 53,900.00 | ||
25 | Terminated | 24/06/2019 | 21/11/2019 | 31/12/2019 | £ 31,500.00 | GBP | Year | Salary | £ 31,500.00 | ||
26 | Full-Time | 01/03/2019 | 29/07/2019 | £ 37,056.25 | GBP | Year | Salary | £ 37,056.25 | |||
Sheet1 |