View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jimmy jimmy is offline
external usenet poster
 
Posts: 2
Default need formula help

I am trying to add mileage for different categories (Charity, Business,
Medical, and Research). Please see this:

http://picasaweb.google.com/jimmy528...51438772699154

How do I get the results in Column G by adding up the Mileage (Column
D). For example, I want a formula that will search through Column A for
"Charity" and know to add cells D14, D16 and D19 resulting in the sum
of "60" in cell G3?

Thanks,
Jimmy