Thread: Sum Data if Column B = Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
  
Posts: 202
Default Sum Data if Column B = Q
I wish to sum all data in Sheet2 Column J, if the value in Sheet2
Column B = The value in Sheet1 Column A

I've tried =SUMPRODUCT(PC_Month_Locations=A8,PC_Month)

Named Ranges above used instead of absolute references
Reply With QuoteReply With Quote