Home

worksheet input

%3CLINGO-SUB%20id%3D%22lingo-sub-441240%22%20slang%3D%22en-US%22%3Eworksheet%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-441240%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20track%20investment%20performance%20by%20month.%20My%20worksheet%20includes%20columns%20for%20sales%20and%20columns%20for%20purchases%20and%20resulting%20values%20in%20other%20columns.%20How%20can%20I%20create%20a%20cell%20that%20shows%20the%20total%20of%20multiple%20transactions%3F%20For%20instance%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Sales%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3Bdate%201%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20shares%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20cost%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20market%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20gain%2Floss%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Band%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3Bdate%202%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bshares%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bcost%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bmarket%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20gain%2Floss%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20and%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3BI%20need%20to%20summarize%20these%20transactions%20on%20one%20line%20so%20subsequent%20columns%20calculate%20accurately.%20The%20cell%20would%20contain%20a%20drop%20down%20indicator.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-441240%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
happy_pat-12
Occasional Visitor

I need to track investment performance by month. My worksheet includes columns for sales and columns for purchases and resulting values in other columns. How can I create a cell that shows the total of multiple transactions? For instance:

                    Sales

   date 1            shares        cost        market        gain/loss     and so on

   date 2             shares       cost         market        gain/loss        and so on

 I need to summarize these transactions on one line so subsequent columns calculate accurately. The cell would contain a drop down indicator.

                      

Related Conversations