Forum Discussion

Copper Contributor

Mar 16, 2022

Solved

Excel Attendance Formula Help: Sum of attendance points for all dates w/in 6 months of infraction

I need a formula to add sum of all points from f column. 1 constraint are Points dropping off after 6 months (180 days plus 1 inclusive date) from start date, and if points are within the TODAY date...

Formulas and Functions

Martin_Weiss
Mar 17, 2022
HiCBHRBP

depending on your local settings, it might be that you need to replace the ; with , in the formula.
So instead of
=SUMIFS(F2:F7;A2:A7;I1;C2:C7;">="&TODAY()-181)
it might be
=SUMIFS(F2:F7,A2:A7,I1,C2:C7,">="&TODAY()-181)

The other thing is, that you need to adjust the cell references to the real situation in your worksheet. When I look at your screenshot, it should be
=SUMIFS(F4:F10,A4:A10,I2,C4:C10,">="&TODAY()-181)

Martin_Weiss

Bronze Contributor

Mar 16, 2022

Hi CBHRBP

you could try it with this formula:

=SUMIFS(F2:F7;A2:A7;I1;C2:C7;">="&TODAY()-181)

CBHRBP
Copper Contributor
Mar 16, 2022
Martin_Weiss

TY. I got an error I tried the formula but noticed it was in the wrong cell/s so I modified but either didn't work. Error came up.

I really appreciate you!
- Martin_Weiss
  Bronze Contributor
  Mar 17, 2022
  HiCBHRBP
  
  depending on your local settings, it might be that you need to replace the ; with , in the formula.
  So instead of
  =SUMIFS(F2:F7;A2:A7;I1;C2:C7;">="&TODAY()-181)
  it might be
  =SUMIFS(F2:F7,A2:A7,I1,C2:C7,">="&TODAY()-181)
  
  The other thing is, that you need to adjust the cell references to the real situation in your worksheet. When I look at your screenshot, it should be
  =SUMIFS(F4:F10,A4:A10,I2,C4:C10,">="&TODAY()-181)
  - CBHRBP
    Copper Contributor
    Mar 17, 2022
    Martin_Weiss you Sir are a true wizard and brilliant! Thank you tremendously!!!!!!! Thank you is an understatement!