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!

--------------------
(Ms-Exl-Learner)
--------------------


"albertmb" wrote:

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

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

"albertmb" wrote in message
...
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