SOLVED

Help needed with exel

%3CLINGO-SUB%20id%3D%22lingo-sub-2029063%22%20slang%3D%22en-US%22%3EHelp%20needed%20with%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029063%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20small%20problem%20with%20exel%2C%20(pardon%20my%20french%2C%20im%20not%20a%20pro%20exel%20user)%3CBR%20%2F%3ESo%20im%20working%20on%20a%20table%20for%20work.%3CBR%20%2F%3E%3CBR%20%2F%3EBasically%20i%20need%20help%20with%20a%20calculation%2C%20have%20a%20image%20here%20too..%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ESo%20what%20i%20need%20is%20for%20the%20Amount%20of%20coloured%20key%20squares%20to%20add%20up%20as%20a%20total%20number.%3CBR%20%2F%3EExaple%3A%20IF%20Person%20%22Jonne%22%20has%202%20red%20days%20marked%20i%20want%20the%20answer%20in%20square%20H7.%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20if%20person%20Cisu%20has%202%20green%20days%20and%20one%20yellow%20the%20answer%20total%20answer%20comes%20in%20square%20H8%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEtc..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20basically%20a%20weekly%20work%20table%2C%20where%20we%20also%20mark%20and%20count%20days%20being%20off%20work%20for%20different%20reasons%20(sick%2C%20personal%2C%20vacation%20etc)%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20cells%20are%20set%20up%20so%20that%20i%20can%20fill%20any%20slots%20with%20the%20keywords%20(L%2C%20H%2C%20S%2CP%20and%20V)%20from%20cell%20C2%20to%20G2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20someone%20understand%20what%20i%20need%20help%20with.%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%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%22Exeltest.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243791i83B61B3AB6E0F81A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Exeltest.PNG%22%20alt%3D%22Exeltest.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029370%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20needed%20with%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917061%22%20target%3D%22_blank%22%3E%40Kaizu%3C%2FA%3E%26nbsp%3BI%20believe%20you%20can%20just%20enter%20the%20following%20formula%20in%20H7%20and%20copy%20it%20down.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTA(C7%3AG7)%0A%0Aor%0A%0A%3DLASKE.A(C7%3AG7)%20in%20Finnish%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIf%20not%2C%20please%20clarify%20what%20exactly%20you%20want%20to%20see%20in%20H7%20and%20downwards%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029454%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20needed%20with%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20worked%20exactly%20as%20i%20wanted.%26nbsp%3B%20Thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20word%20%22count%20or%20laske%22%20misdirected%20me%20first%20since%20it%20was%20supposed%20to%20count%20letters%2C%20not%20numbers.%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3CBR%20%2F%3EBut%20main%20thing%20is%20that%20it%20worked.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a small problem with exel, (pardon my french, im not a pro exel user)
So im working on a table for work.

Basically i need help with a calculation, have a image here too.. 

So what i need is for the Amount of coloured key squares to add up as a total number.
Exaple: IF Person "Jonne" has 2 red days marked i want the answer in square H7.

And if person Cisu has 2 green days and one yellow the answer total answer comes in square H8

 

Etc.. 

 

This is basically a weekly work table, where we also mark and count days being off work for different reasons (sick, personal, vacation etc) 

The cells are set up so that i can fill any slots with the keywords (L, H, S,P and V) from cell C2 to G2

 

Hopefully someone understand what i need help with.  

 

Exeltest.PNG

3 Replies
best response confirmed by Kaizu (New Contributor)
Solution

@Kaizu I believe you can just enter the following formula in H7 and copy it down.

=COUNTA(C7:G7)

or

=LASKE.A(C7:G7) in Finnish

If not, please clarify what exactly you want to see in H7 and downwards, 

@Riny_van_Eekelen 

That worked exactly as i wanted.  Thank you

That word "count or laske" misdirected me first since it was supposed to count letters, not numbers.  
But main thing is that it worked. 



@Kaizu Great! glaD I could help.

 

For clarity, COUNT will count only numbers, whereas COUNTA will count all non-blank cells.