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 SumProduct

I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the same
makes/models due to different territories.

I have a separate worksheet for which I need to summarize this info.
What would be the best formula for this task? I guess I am lost on what to
enter to count.

Any help is greatly appreciated!

Thank you,