My friend The list do not show Format shape And chang chart type Office 2010
@satyaveerprasad85066 жыл бұрын
Need formula base excel sheet
@ManikandanRaju6 жыл бұрын
Dear PK: An Excel Expert, I have a doubt in cumulative sum. I am thinking of this all day and night for past few days and I couldn't get a solution. Later I thought of going to an expert and eventually that's why I text you. Here is the sample question.. Column-A: Invoice number. Column-B: Particulars. Column-C: Amount. Column-D: Total Invoice amount. Example: A1: 01, B1: Ball, C1: 100 A2: 02, B2: Clock, C1: 500 A3: 02, B3: Bag, C3: 600 In this above example you can see that there are 2 products for Invoice# 02. Now, how can we get the total of Invoice# 02 (both the lines A2 & A3) in the cell D3 , without displaying any amount in D2? Like this: A1: 01, B1: Ball, C1: 100, D1: 100 A2: 02, B2: Clock, C1: 500, D2: - A3: 02, B3: Bag, C3: 600, D3: 1100 Please Please Please help me on this. I would be really thankful for you. Also please let me know if there is anything that I should get you from my end.