-2

I want to sum values associated with specific words. For example, calculate Sum for Food:

Column A        Column B 
Food             $8.50 
Food             $5.10 
Maintenance      $12.00 
Laundry          $13.00 
Loan             $1,213.25 
Tution           $100.00

The result would be $13.60.

Please let me know which formula I can use

fixer1234
  • 28,064
Nitin
  • 1

1 Answers1

0

You can use the SUMIF function as below. You can replace 'Food' with any other word, or preferably a reference to another cell which tells it what word to look for. It looks for the value in column A, then sums the corresponding values from B.

=SUMIF($A$2:$A$7,"Food",$B$2:$B$7)

Steve can help
  • 554