Tabulating entries with a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1560674%22%20slang%3D%22en-US%22%3ETabulating%20entries%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560674%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20track%20entries%20into%20cells.%20I%20will%20actually%20be%20posting%20currency%20numbers%20in%20each%20cell%2C%20but%20also%20want%20to%20be%20able%20to%20track%20how%20many%20cells%20have%20entries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20attached%3A%26nbsp%3B%20The%20answer%20in%20%22days%20srv%22%20should%20be%20%225%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1560674%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-1560757%22%20slang%3D%22en-US%22%3ERe%3A%20Tabulating%20entries%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746904%22%20target%3D%22_blank%22%3E%40trumpet717%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThe%20quick%20answer%20is%20to%20use%20the%20COUNT%20function.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPut%20this%20in%20%22days%20srv%22%20column%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3E%3CFONT%20color%3D%22%230000FF%22%3E%3DCOUNT(C2%3AG2)%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%20%26nbsp%3B%20%26nbsp%3BReplicate%20down%20the%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20will%20give%20a%20count%20of%20numbers%20but%20will%20ignore%20text%2C%20etc.%26nbsp%3B%20As%20long%20as%20you're%20just%20entering%20currencies%20(numbers)%2C%20the%20COUNT%20function%20should%20be%20fine.%26nbsp%3B%20If%20you%20need%20more%20complex%20counting%2C%20have%20a%20look%20at%20the%20COUNTA%20or%20COUNTIF%20functions.%26nbsp%3B%20Excel%20HELP%20explains%20how%20each%20function%20works.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPost%20back%20if%20you%20still%20need%20help.%26nbsp%3B%20%3CFONT%20color%3D%22%23800080%22%3E%3CEM%3E~RonR%3C%2FEM%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560769%22%20slang%3D%22en-US%22%3ERe%3A%20Tabulating%20entries%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560769%22%20slang%3D%22en-US%22%3E%3CP%3ERon-%20quite%20helpful%20to%20begin%20with!%3C%2FP%3E%3CP%3ENow%20I'm%20attaching%20a%20larger%20version.%20Please%20note%20the%20spreadsheet%20hides%20certain%20columns%2C%20as%20I%20use%20those%20cells%20for%20another%20tracking%20(weekly%20avg.).%20How%20would%20I%20include%20all%20the%20visible%20cells%20into%20the%20total%20in%20column%20B%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746931%22%20target%3D%22_blank%22%3E%40Ruoschalet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560770%22%20slang%3D%22en-US%22%3ERe%3A%20Tabulating%20entries%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560770%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%2C%20make%20that%20column%20E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746931%22%20target%3D%22_blank%22%3E%40Ruoschalet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am looking to track entries into cells. I will actually be posting currency numbers in each cell, but also want to be able to track how many cells have entries.

 

An example attached:  The answer in "days srv" should be "5".

3 Replies

@trumpet717   The quick answer is to use the COUNT function. 

 

Put this in "days srv" column:     =COUNT(C2:G2)     Replicate down the column.

This will give a count of numbers but will ignore text, etc.  As long as you're just entering currencies (numbers), the COUNT function should be fine.  If you need more complex counting, have a look at the COUNTA or COUNTIF functions.  Excel HELP explains how each function works. 

 

Post back if you still need help.  ~RonR

Ron- quite helpful to begin with!

Now I'm attaching a larger version. Please note the spreadsheet hides certain columns, as I use those cells for another tracking (weekly avg.). How would I include all the visible cells into the total in column B?

 

@Ruoschalet 

Sorry, make that column E.

 

@Ruoschalet