summing and searching with words and numbers in different columns

[juskojj]

I'm looking to do the following below: column A would have numbers, column B would have words and a few columns over i would have the total of each same word

column A column B
60 house
120 car
30 misc
52.25 food
83.33 gas house 180.25
120.25 house car 120
25 misc misc 55
105 food food 157.25
50.5 gas gas 133.83

any help i can get would be appreciated, even if it can't be done i've attached a file if this doesn't come through well
Thanks!!!!

[rylo]

Hi

Using your example file
F5: =SUMIF($B$1:$B$9,E5,$A$1:$A$9)
Copy down to F8

rylo

[juskojj]

Thanks!!! that was much easier then i was expecting!