SOLVED

Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2571935%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571935%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20formula%20that%20will%20work%20to%20add%20up%20a%20column%20that%20is%20not%20numerical%3F%20For%20example%2C%20if%20you%20need%20to%20calculate%20the%20amount%20of%20times%20a%20cell%20is%20occupied%20against%20how%20many%20times%20it%20is%20not%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2571935%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%3CLINGO-SUB%20id%3D%22lingo-sub-2571982%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571982%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1109400%22%20target%3D%22_blank%22%3E%40nicoleireland5%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3DCOUNTBLANK(A2%3AB5)%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3ECounts%20empty%20cells%20in%20the%20range%20above.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcountblank-function-6a92d772-675c-4bee-b346-24af6bd3ac22%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECOUNTBLANK%20function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3DCOUNTA(A2%3AA7)%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3ECounts%20the%20number%20of%20nonblank%20cells%20in%20cells%20A2%20through%20A7.%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcount-nonblank-cells-30daa495-82da-4cfa-958d-adf11b3d4054%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECount%20nonblank%20cells%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there a formula that will work to add up a column that is not numerical? For example, if you need to calculate the amount of times a cell is occupied against how many times it is not?

1 Reply
best response confirmed by nicoleireland5 (New Contributor)
Solution

@nicoleireland5 

=COUNTBLANK(A2:B5)

Counts empty cells in the range above.

COUNTBLANK function

 

 

=COUNTA(A2:A7)

Counts the number of nonblank cells in cells A2 through A7.

Count nonblank cells

 

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.