I need help with addition formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2106682%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20addition%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106682%22%20slang%3D%22en-US%22%3E%3CP%3ELet%20first%20start%20by%20explaining%20background.%20I%20need%20to%20calculate%20total%20Absences.%26nbsp%3B%3C%2FP%3E%3CP%3E2%20tardies%20-%201%20absence.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20need%20to%20be%20able%20to%20look%20at%20the%20tardy%20column%20and%20for%20every%202%20tardies%20I%20need%20to%20add%201%20absence.%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20total%20absences%20will%20be%20all%20absences%20plus%20the%20tardies.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20I%20can%20use%20to%20do%20this%20calculation%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KHenneke2280_0-1611849492660.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F250313i64C292F44A5FC57C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KHenneke2280_0-1611849492660.png%22%20alt%3D%22KHenneke2280_0-1611849492660.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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