SOLVED

SUM total values expressed for populated cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2455964%22%20slang%3D%22en-US%22%3ESUM%20total%20values%20expressed%20for%20populated%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455964%22%20slang%3D%22en-US%22%3E%3CP%3ESimple%20formula%20required%20to%20populate%20the%20number%20of%20populated%20cells%20below%2C%20expressed%20as%201%2C2%2C3%20etc..%20per%20populated%20cell-%20can%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2455964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2455994%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20total%20values%20expressed%20for%20populated%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455994%22%20slang%3D%22en-US%22%3EWith%20that%20brief%20description%2C%20all%20we%20can%20do%20is%20suggest%20possibilities.%20Look%20at%20the%20COUNT%20and%20COUNTA%20functions%2C%20possibly%20COUNTIF...%20if%20none%20of%20those%20helps%2C%20maybe%20you%20could%20come%20back%20with%20a%20more%20complete%20description%2C%20even%20(ideally)%20a%20copy%20of%20the%20spreadsheet%20in%20which%20you%20want%20this%20counting%20to%20take%20place.%3C%2FLINGO-BODY%3E
New Contributor

Simple formula required to populate the number of populated cells below, expressed as 1,2,3 etc.. per populated cell- can anyone help?

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
With that brief description, all we can do is suggest possibilities. Look at the COUNT and COUNTA functions, possibly COUNTIF... if none of those helps, maybe you could come back with a more complete description, even (ideally) a copy of the spreadsheet in which you want this counting to take place.

Thank you @mathetes 

 

COUNT function works perfectly -appreciate your input