Jan 28 2021 08:00 AM
Let first start by explaining background. I need to calculate total Absences.
2 tardies - 1 absence.
So I need to be able to look at the tardy column and for every 2 tardies I need to add 1 absence.
To total absences will be all absences plus the tardies.
Is there a formula I can use to do this calculation?
Jan 28 2021 08:56 AM
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.
With a file, for example, I would certainly try to answer, because I know that my formulas from German into your Excel are automatically converted into your language, without having to search for a formula translator myself.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Jan 28 2021 10:29 AM
=SUM([Absent])+INT(SUM([Tardy])/2)
if that is an actual table you can use those reference (i.e. Table1[Absent]) but if not you can replace them with the relevant range.
Jan 28 2021 11:50 AM
This worked perfectly! Thank you @mtarler