formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1438445%22%20slang%3D%22en-US%22%3Eformulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438445%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%20I%20am%20having%20an%20issue%20with%20some%20formulas%20that%20I%20need%20to%20write%20to%20get%20the%20data%20on%20my%20spreadsheet%20to%20work.%20I%20have%20a%20sum%20formula%20right%20now%20in%20lets%20say%20d2%20that%20is%20working%20alright%20but%20i%20need%20to%20add%20a%20few%20more%20cells%20that%20will%20change%20the%20totals.%20i%20have%20the%20totals%20in%20d4%20and%20i%20have%20a%20formula%20in%20there%20now%20to%20compute%20d2%2Cd3%20data%20buit%20i%20need%20to%20add%20secondary%20cells%20to%20this%20formula%20that%20will%20also%20change%20the%20total%20amounts.%20does%20anyone%20in%20here%20know%20how%20i%20could%20go%20about%20doing%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1438445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Good Day I am having an issue with some formulas that I need to write to get the data on my spreadsheet to work. I have a sum formula right now in lets say d2 that is working alright but i need to add a few more cells that will change the totals. i have the totals in d4 and i have a formula in there now to compute d2,d3 data buit i need to add secondary cells to this formula that will also change the total amounts. does anyone in here know how i could go about doing that ?

 

 

1 Reply
Hi, can you post a sample of the data you're working with and if you could describe how you want it to work. I can't decipher entirely from your questions what you want each column to represent.

For example, what is D2 a sum of/what do you want it to be, what do you want D3 to be, what do you want D4 to be, etc.

I'm sure we can figure out how to accomplish what you need, just need a little more info!

Thanks - Dustin