SUMPRODUCT PROBLEM

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
 
M

Ms-Exl-Learner

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!
 
F

Fred Smith

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
 
Top