View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cameron Cameron is offline
external usenet poster
 
Posts: 42
Default Combining Lookup function and Sum function

I am trying to use the lookup function to find all values in a spreadsheet
matching "D" then returning the value to the left of it. I would like the
function to sum all the values before it is returned. Is this possible to do
in one step?