LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mike
 
Posts: n/a
Default look up function and sum values

I have a large spreadsheet that has vendor #s in column A and amounts in
column B. How do i get excel to look at all the matching vendor #s in column
A and add up all the corresponding values in column C and return the vendor #
and totals? There are multiple orders from the same vendors and I just want a
total for each returned along with the vendor #.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"