Formula in excel

momas
momas used Ask the Experts™
on
how i can for advance formula in excel for attached file that in on cell(E1) get the result of
(A1*D1)+ (A2*D1)+(A3*D1)+(A4*D1)+(A5*D1)+(A6*D1)
if only what in column B1,B2,B3,B4,B5,B6 is = T
for.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
=SUMPRODUCT((A1:A6)*(D1:D6)*(B1:B6="T"))
Rob HensonFinance Analyst

Commented:
In your example, how are you getting a result of 3?

D1 in your sample is blank.

Author

Commented:
Sorry it by mistake and the above  formula by Mr Saqib is work fine with me

=SUMPRODUCT((A1:A6)*B8*(B1:B6="T"))

Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial