View Single Post
  #1   Report Post  
johnsvolition
 
Posts: n/a
Default Looking for function to pick out names and at values from the same row


Say I have 3 Rows:

Income | Expanses | Memo
| 10.00 | Food
| 5.00 | Gas
| 15.00| Food

Now I'm looking for a function that searches for a string such as
"Food" and then add all Values of the Expanses Tab of this certain tab,
so that all values of Food will be added automatically so that the
result of this would be 25.00...

I would really appreciate any help


--
johnsvolition
------------------------------------------------------------------------
johnsvolition's Profile: http://www.excelforum.com/member.php...o&userid=27263
View this thread: http://www.excelforum.com/showthread...hreadid=467730