ADJUST SUMIF TO SUM DATA STARTING FROM A SPECIFIED DATE IN A DATA SET

[JuicyMusic]

Hi Guru's,
I have a 2 criteria SUMIF that I need to add a 3rd criteria to. Right now the formula sums nicely based on employee name and summing the PR deduction throughout the year for that employee.

I need to adjust the formula to start summing FROM a specific date (entered in a helper cell) and continue summing any data row dated after that specific date.
The data set is a payroll deduction export that is run weekly. Payroll dates for the year will be from 12/1/20 to 11/30/21 (for this year).

Here is my formula (column K) with a small data set. My employer doesn't allow me to use the XL2BB.

I have the "Start Summing Date" cell in red text. If the cell is empty then just sum everything. If there is a date in that box then sum everything but start from that date (see red text).

=SUMIF(F33:F44,J33,H33:H44)

Thank you so much!,

Juicy,

 

[Fluff]

How about

=SUMIFS(H33:H44,F33:F44,J33,G33:G44,">"&L32)

 

[JuicyMusic]

Hi Fluff, That's almost what I did. I think I'll like yours better because I won't have to link to a cell with an END date.
I'm going to try yours right now.

Here is my adjusted formula so you can see.

=SUMIFS(H49:H95,G49:G95,">="&L48,G49:G95,"<="&M48,F49:F95,J49)

 

[JuicyMusic]

YOU ARE AWESOME! I do like yours better. SOLVED.

The only thing I did was add an equals sign to it....but you solved this for me.

=SUMIFS(H33:H44,F33:F44,J33,G33:G44,">="&L32)

 

[Fluff]

Glad to help & thanks for the feedback.