Thread: Sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Sumproduct

SHeet 2

Column a (rows 13 thru 49) contains products
COlumn c (rows 13 thru 49) contains vendor
Column Q (rows 13 thru 49) contains spend

Sheet 1

Column a contains products
column b contains vendor
column c contains spend

I need a formula that will calculate the toatal spend by product by vendor

thanks