I need help with addition formula

Copper Contributor

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?

 

KHenneke2280_0-1611849492660.png

 

 

3 Replies

@KHenneke2280 

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)

@KHenneke2280 

=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.

 

This worked perfectly! Thank you @mtarler