S
Samuel
If anyone can help me with this, I would be greatful. I created a very
simplified version of my problem below, but an answer to this can
solve my real problem. I am at a loss on how to associate the expense
next to the name with the dollar value in another column, then
maintain a running sum for each individual.
I have an expense sheet that has expenses by name, (ie car) and
another that assigns a dollar value to that car.
Each name can have multiple expenses (ie below fred has car car misc
meal). Nbr 1 below.
Another section, Nbr 2 below, assigns an expense value to each item.
I need a formula that answers nbr 3 Cells B5 through B8. It says: this
person had these four items, it checks the value of the each, adds
them up and gives me a total expense....
1)
A B C D E
1 fred car car misc meal
2 mike meal car phone misc
3 jim meal phone car misc
4 bill phone misc meal meal
2)
A B
5 car 100
6 meal 50
7 phone 10
8 misc 25
3)
A B
9 fred 275<------- Need formula for this column
10 mike 185
11 jim 185
12 bill 135
Any help greatfully appreciated!
simplified version of my problem below, but an answer to this can
solve my real problem. I am at a loss on how to associate the expense
next to the name with the dollar value in another column, then
maintain a running sum for each individual.
I have an expense sheet that has expenses by name, (ie car) and
another that assigns a dollar value to that car.
Each name can have multiple expenses (ie below fred has car car misc
meal). Nbr 1 below.
Another section, Nbr 2 below, assigns an expense value to each item.
I need a formula that answers nbr 3 Cells B5 through B8. It says: this
person had these four items, it checks the value of the each, adds
them up and gives me a total expense....
1)
A B C D E
1 fred car car misc meal
2 mike meal car phone misc
3 jim meal phone car misc
4 bill phone misc meal meal
2)
A B
5 car 100
6 meal 50
7 phone 10
8 misc 25
3)
A B
9 fred 275<------- Need formula for this column
10 mike 185
11 jim 185
12 bill 135
Any help greatfully appreciated!