View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brandy Brandy is offline
external usenet poster
 
Posts: 52
Default Count if or Sum Product

I apologize if this is a duplicate submission.

I have a spreadsheet of data with two columns of data for which I need to
summarize on another spreadsheet. Column A lists makes/models and Column B
counts the number sold. The original spreadsheet will contain multiple
duplicate entries of the same makes/models for which I need to summarize.

Ex:
Column A Column B
7444 loader 2


Which formula would be best for this project?

Thank you!