How to make a cell count just 1 number if there is 2 or 1?

%3CLINGO-SUB%20id%3D%22lingo-sub-1766897%22%20slang%3D%22en-US%22%3EHow%20to%20make%20a%20cell%20count%20just%201%20number%20if%20there%20is%202%20or%201%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766897%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EI%20work%20with%20disabled%20people%20and%20in%20this%20project%20we%20do%20a%20lot%20of%20different%20activities%2C%20so%20things%20you%20need%20to%20know%20to%20help%20me%20if%20you%20can.%3C%2FP%3E%3CP%3E-%20We%20do%202%20Activities%20per%20day.%3C%2FP%3E%3CP%3E-%20There%20are%202%20fields%20per%20activitie%20that%20we%20use%20to%20classify%20the%20evolution%20of%20the%20kids%20CP%20(Behaviour)%20and%20PT%20(Participation)%3C%2FP%3E%3CP%3E-%20But%20I%20also%20want%20these%20board%20to%20check%20daily%20presences%20(attendance)%2C%20because%20some%20kids%20just%20come%20to%20activity%201%20or%20activity%202%20and%20miss%20the%20other%2C%20I%20want%20these%20to%20count%20as%20a%20presence%20also%20so%2C%20the%20Z%20column%20count%20all%20activity%201%20presences%2C%20the%20AA%20count%20all%20activity%202%20presences%20and%20I%20want%20the%20AB%20to%20count%20all%20the%20presences%20in%20the%20week.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%2C%20if%20I%20divided%20by%202%2C%26nbsp%3B%201%2F2%3D0%2C5%20rounded%20up%20is%20one%2C%20but%20if%20I%20have%202%20presences%20in%20both%20days%201%20and%202%2C%20it%20will%20be%202%2F2%3D1...%20any%20ideas%20how%20I%20can%20solve%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.27.27.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F225702i2FDA5631BED93EAA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.27.27.png%22%20alt%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.27.27.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.58.34.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F225703i75B045DA2B78AE10%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.58.34.png%22%20alt%3D%22Captura%20de%20ecra%CC%83%202020-10-10%2C%20a%CC%80s%2007.58.34.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767371%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20make%20a%20cell%20count%20just%201%20number%20if%20there%20is%202%20or%201%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827201%22%20target%3D%22_blank%22%3E%40nunomiguelneto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20your%20screenshot%20it's%20not%20clear%20where%20are%20days%20and%20where%20are%20attendances%2C%20and%20how%20you%20received%201%20in%20Z%20and%20AA%20on%20first%20screenshot.%20It's%20better%20to%20submit%20sample%20file%20with%20formulas%20you%20use%20now%20and%20manually%20added%20desired%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1771906%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20make%20a%20cell%20count%20just%201%20number%20if%20there%20is%202%20or%201%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1771906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827201%22%20target%3D%22_blank%22%3E%40nunomiguelneto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%20for%20the%20file%2C%20it's%20more%20clear%20now.%3C%2FP%3E%0A%3CP%3EPerhaps%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20410px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226033i92737C0340807124%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eit'll%20be%20simply%20maximum%20of%20two%2C%20please%20check%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,

I work with disabled people and in this project we do a lot of different activities, so things you need to know to help me if you can.

- We do 2 Activities per day.

- There are 2 fields per activitie that we use to classify the evolution of the kids CP (Behaviour) and PT (Participation)

- But I also want these board to check daily presences (attendance), because some kids just come to activity 1 or activity 2 and miss the other, I want these to count as a presence also so, the Z column count all activity 1 presences, the AA count all activity 2 presences and I want the AB to count all the presences in the week. 

 

My problem is, if I divided by 2,  1/2=0,5 rounded up is one, but if I have 2 presences in both days 1 and 2, it will be 2/2=1... any ideas how I can solve this?

Captura de ecrã 2020-10-10, às 07.27.27.pngCaptura de ecrã 2020-10-10, às 07.58.34.png

5 Replies

@nunomiguelneto 

From your screenshot it's not clear where are days and where are attendances, and how you received 1 in Z and AA on first screenshot. It's better to submit sample file with formulas you use now and manually added desired result.

@Sergei Baklan Hello Sergei, thank you so much, here is the sample file

@nunomiguelneto 

Thank you for the file, it's more clear now.

Perhaps here

image.png

it'll be simply maximum of two, please check attached.

@Sergei Baklan Thank you so much Sergei... it was basic... sometimes the answer is right under my nose and I cannot find it. 

@nunomiguelneto 

No problem, such happens with each of us from time to time