Find exact name and Sum the value

[23andybass]

Hi!

I having a little bit of trouble here... I want to type a name and according to that name I want to add the value of that name. I'm using LOOKUP but whenever I type the same name the value goes back to the default and it won't add it to the correct place. I hope with the pictures it would be more clear.

In this first picture you can see how it adds it up but the problem is that the name is not the same

https://drive.google.com/file/d/0B_pB5nAB8sWVcTByRDhleTQ4eXc/view?usp=sharing

In this second picture you can see how when I add a new name the value goes back to default.

https://drive.google.com/open?id=0B_pB5nAB8sWVM2JZellkZnd2WUk

In this third you can see how it didn't add up all the amount correctly

https://drive.google.com/open?id=0B_pB5nAB8sWVRlluUlNwc1Y4TTg

In this fourth one you can see the formula

https://drive.google.com/open?id=0B_pB5nAB8sWVWHE3cG9Oa0NEbm8

In the last one you can see all the table

https://drive.google.com/open?id=0B_pB5nAB8sWVaFJpMW51di1IY0U


Thanks for all your help

 

[Marcílio_Lobão]

23andybass, Good evening.

Since the value in the "GASTO" column means expenditure, it is not necessary to enter the minus sign (-).
Enter the normal value.

Try to use:
G4 -> =F4 - SUMIF($I$4:$I$8, E4, $J$4:$J$8)

Is that what you wanted?
I hope I've helped.

 

[FDibbins]

Not able to view your images, can you show some sample data here please?

 

[Marcílio_Lobão]

Dear FDibbins, Good evening.


I had no problem seeing the images.
I put them here to see if you can see them now.

I hope I've helped.

Image 1

Image 2

Image 3

Image 4

 

[Marcílio_Lobão]

Image 5

 

[FDibbins]

Marcílio, thanks for the assist, but no, I still cannot see them all (can see 3 and 4). Some browsers have a problem viewing certain image types, were 1 and 2 .png and 3 and 4 .jpg, perhaps?

 

[23andybass]

Dude... you save me!! That's what I was looking for... seriously thanks!!!