gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
Looking to sum the Total (K:K) for the last day of each month (A:A) in a single formula.
Thank you.
Looking to sum the Total (K:K) for the last day of each month (A:A) in a single formula.
Thank you.
BJs Income & Schedule.xlsm | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | 1/7/2022 | $360.38 | 23.25 | $21.62 | $22.35 | $5.22 | $0.00 | $27.57 | $311.18 | ||||
2 | 1/14/2022 | $373.24 | 24.08 | $22.39 | $23.15 | $5.41 | $0.00 | $28.56 | $322.29 | ||||
3 | 1/21/2022 | $316.98 | 20.45 | $19.02 | $19.66 | $4.59 | $0.00 | $24.25 | $273.71 | ||||
4 | 1/28/2022 | $300.39 | 19.38 | $18.02 | $18.63 | $4.35 | $0.00 | $22.98 | $259.38 | ||||
5 | 1/31/2022 | 87.16 | $1,166.56 | ||||||||||
6 | 2/4/2022 | $298.69 | 19.27 | $17.92 | $18.52 | $4.33 | $0.00 | $22.85 | $257.91 | ||||
7 | 2/11/2022 | $296.36 | 19.12 | $17.78 | $18.38 | $4.30 | $0.00 | $22.67 | $255.91 | ||||
8 | 2/18/2022 | $479.26 | 30.92 | $28.76 | $29.72 | $6.95 | $0.00 | $36.67 | $413.84 | ||||
9 | 2/25/2022 | $448.42 | 28.93 | $26.90 | $27.81 | $6.50 | $0.00 | $34.31 | $387.20 | ||||
10 | 2/28/2022 | 98.24 | $1,314.86 | ||||||||||
11 | 3/4/2022 | $180.27 | 11.63 | $10.82 | $11.18 | $2.61 | $0.00 | $13.79 | $155.66 | ||||
12 | 3/11/2022 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
13 | 3/18/2022 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
14 | 3/25/2022 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
15 | 3/31/2022 | 11.63 | $155.66 | ||||||||||
16 | |||||||||||||
17 | Total: | $2,637.08 | |||||||||||
18 | Test: | ??? | |||||||||||
19 | sum total for last day of month | ||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G11:G14,G6:G9,G1:G4 | G1 | =B1*0.062011088 |
H11:H14,H6:H9,H1:H4 | H1 | =B1*0.014495 |
I11:I14,I6:I9,I1:I4 | I1 | =IF($B1>500,$B1*0.004812,"$0.00") |
J11:J14,J6:J9,J1:J4 | J1 | =SUM(G1:I1) |
B11:B14,B6:B9,B1:B4 | B1 | =$C1*15.5 |
D11:D14,D6:D9,D1:D4 | D1 | =B1*0.06 |
C5,K15,K10,K5,C15,C10 | C5 | =SUM(C1:C4) |
A12:A14,A7:A9,A2:A4 | A2 | =A1+7 |
A5,A15,A10 | A5 | =EOMONTH(A2,0) |
A6,A11 | A6 | =A4+7 |
K11:K14,K6:K9,K1:K4 | K1 | =(B1-D1)-J1 |