• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Summation

S

subhi

Member
based on the attached sheet.

In colomn A there are 2 groups "Homw and Work", I need an excel formula which provide me the summation for all cost values in colomn D for each group, even if I insert a row unded each group it should be automaticaly calculate the new cost value.

the first group summation should be in cell D2 and the second in D13.
 

Attachments

  • Summation.csv
    163 bytes · Views: 6

subhi​

There is same challenge as with Your previous thread

Correct Excel formula

In the attached sheet....... the cells B2,D2,F2,H2 are IDs and some of them have the same ID "FON", and the cells A2,C2,E3,G3 are the names of those IDs. I need an excel formula to find the name which matchs the first ID "FON" which will be applied in cell L1 also the name which matchs the...
chandoo.org
You've attached .csv-file - instead of an Excel-file.
... or ...
Where do You expect to get .... an excel formula in Your .csv-file?
What are Your expected results?
If You'll new rows in Your .csv-file ... do You need new costs at once?
...
Ps. You seems to skipped to comment some of Your previous thread solutions too.
 
vletm said:

subhi​

There is same challenge as with Your previous thread

Correct Excel formula

In the attached sheet....... the cells B2,D2,F2,H2 are IDs and some of them have the same ID "FON", and the cells A2,C2,E3,G3 are the names of those IDs. I need an excel formula to find the name which matchs the first ID "FON" which will be applied in cell L1 also the name which matchs the...
chandoo.org
You've attached .csv-file - instead of an Excel-file.
... or ...
Where do You expect to get .... an excel formula in Your .csv-file?
What are Your expected results?
If You'll new rows in Your .csv-file ... do You need new costs at once?
...
Ps. You seems to skipped to comment some of Your previous thread solutions too.
Click to expand...
I shared an excel file and the total cost for group "Home" in cell D2 and equals 40, and the group "Work" in cell D13 and equals 50.
once adding new row under any of groups I need to add its cost to the previous cost.
 

Attachments

  • Summation.xlsx
    10.2 KB · Views: 3
You must log in or register to reply here.
Back
Top