Spreadsheet: 870743d1717186577-sumproduct-formula-help-to-attain-information-given-specific-conditions-test
Sheet: Sheet1

Pay Schedule |  |  |  |  |  |  | Pay Breakdown
 |  | Triple Pay Months | Phone Stipend |  |  |  |  | Bi-Weekly | Monthly |  |  |  | I get a phone stipend once per month on an alternating two week
1 | 2024-01-05 00:00:00 |  |  |  |  |  | Hours | 80 |  |  |  |  | basis.  I need that to show up on the Bi-weekly cell (I7) only during
2 |  |  | True |  |  |  | Hourly Pay | 1 | 1 |  |  |  | the two weeks after the date I receive it.  Example:  [NAME] has date
3 |  |  |  |  |  |  | Bonus |  |  |  |  |  | 1/19/24 which has a True statement in the D column next to it.
4 |  |  | True |  |  |  | Stipends |  | 50 |  |  |  | I need 50 dollars to show in I7 starting 1/19 and automatically
5 |  |  |  |  |  |  | Total |  |  |  |  |  | removing itself when the next pay period starts on 3/1/24.
6 |  |  | True |  |  |  |  |  |  |  |  |  | I started a formula already, but I'm not quite sure how to logic it out.
7 |  |  |  |  |  |  | Pre-tax Deductions
8 |  |  | True |  |  |  | Total After Taxes |  |  |  |  |  | Formula for Phone Stipend:
9 |  |  |  |  |  |  | Post-tax Deductions |  |  |  |  |  | Test Date: |  |  | 2023-01-04 00:00:00
10 |  |  | True |  |  |  | Total Deductions
11 |  |  |  |  |  |  | Total Taxes |  |  |  |  |  | Not sure how to finish the day portion of the formula, assuming I'm
12 |  |  | True |  |  |  | Tithe & Offerings |  |  |  |  |  | on the right track.
13 |  |  |  |  |  |  | Tithe
14 |  |  | True |  |  |  | Offerings
15 |  |  |  |  |  |  | Taxes
16 |  |  | True |  |  |  | Federal Tax
17 |  |  |  |  |  |  | Social Security
18 |  |  | True |  |  |  | Medicare
19 |  |  |  |  |  |  | Long Term Care Employee
20 |  |  | True |  |  |  | Family Leave Insurance
21 |  |  |  |  |  |  | WA WC Tax
22 |  |  | True |  |  |  | Pre-tax Deductions
23 |  |  |  |  |  |  | 401k | 196.03
24 |  |  | True |  |  |  | HSA | 57.69
25 |  |  |  |  |  |  | Parking | 30
26 |  |  | True |  |  |  | Medical | 25.75
27 |  |  |  |  |  |  | Dental | 15
28 |  |  | True |  |  |  | Post-tax Deductions
29 |  |  |  |  |  |  | Identity Theft Insurance | 6.69
30 |  |  | True |  |  |  | Supplimental Life EE | 4.55
31 |  |  |  |  |  |  | Supplimental Life Insurance ([NAME]) | 2.49
32 |  |  | True |  |  |  | Accident Insurance ATax | 4.26
33 |  |  |  |  |  |  | Supplimental ADD ATax (Dawn) | 1.33
34 |  |  | True |  |  |  | Supplimental ADD ATax ([NAME]) | 1.18
35 |  |  |  |  |  |  | Supplimental Life EE Adj | 0.13
36 |  |  | True |  |  |  | Supplimental ADD ATax Adj | 0.04
37 |  |  |  |  |  |  | Non-Cash Deductions
38 |  |  | True |  |  |  | GTL Over 50k | 13.38
39 |  |  |  |  |  |  | GTL Over 50k Adj | 0.46
40 |  |  | True |  |  |  | Non-Cash Additions
41 |  |  |  |  |  |  | GTL Over 50k | 13.38
42 |  |  | True |  |  |  | GTL Over 50k Adj | 0.46
43
44 |  |  | True
45
46 |  |  | True
47
48 |  |  | True
49
50 |  |  | True
51
52 |  |  | True
53
54 |  |  | True
55
56 |  |  | True
57
58 |  |  | True
59
60 |  |  | True
61
62 |  |  | True
63
64 |  |  | True
65
66 |  |  | True
67
68 |  |  | True
69
70 |  |  | True
71
72 |  |  | True
73
74 |  |  | True
75
76 |  |  | True
77
78 |  |  | True
79
80 |  |  | True