SUMPRODUCT PROBLEM

  • Thread starter Thread starter albertmb
  • Start date Start date
A

albertmb

Hi Everyone, I am using the following formula but I am getting an error in
formula message, can anyone help me please,

SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1))*(('Client Opening
Stock'!C1:AH1=A7)),'Client Opening Stock'!C2:X138)

Thank You for your continuous support
 
Try this…

=SUMPRODUCT(('Client Opening Stock'!$B$2:$B$138=Sheet2!A1)*('Client Opening
Stock'!$C$1:$AH$1=Sheet2!A7)*('Client Opening Stock'!$C$2:$AH$138))

Remember to Click Yes, if this post helps!
 
Your brackets are misplaced. Try:
=SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1)*('Client Opening
Stock'!C1:AH1=A7),'Client Opening Stock'!C2:X138)

Regards,
Fred
 
Back
Top