momas
asked on
Formula in excel
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)+(A 5*D1)+(A6* D1)
if only what in column B1,B2,B3,B4,B5,B6 is = T
for.xlsx
(A1*D1)+ (A2*D1)+(A3*D1)+(A4*D1)+(A
if only what in column B1,B2,B3,B4,B5,B6 is = T
for.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
=SUMPRODUCT((A1:A6)*B8*(B1
Thank you
D1 in your sample is blank.