Summation

[subhi]

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.

 

[vletm]

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.

 

[subhi]

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.

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.

 

[pecoflyer]

Make your ranges an Excel Table and use it to sum the ranges. Whenever you add rows, they will be added automatically

 

[vletm]

Without Your answers with an Excel-file.
This seems to work ...

 

[subhi]

Without Your answers with an Excel-file.
This seems to work ...

It works fine, Many thanks for your support and cooperation.