Formula question.

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

The formula below is what I am using which does what I
want in my workbook.
Question E2:E6002, F2:6002, G2:G6002 I would like it to
look in master.xls as the source, as I want to target it
to the workbook that I am in. ie 005.xls

SUMPRODUCT(--(E2:E6002=A1),--(F2:F6002=B1),G2:G6002)

Thankyou
 
Hi Steved
if your lookup ranges reside in your master workbook try
=SUMPRODUCT(--('[master]sheet1'!E2:E6002=A1),--('[master]sheet1'!F2:F60
02=B1),'[master]sheet1'!G2:G6002)

Frank
 
Thankyou, thankyou.
-----Original Message-----
Hi Steved
if your lookup ranges reside in your master workbook try
=SUMPRODUCT(--('[master]sheet1'!E2:E6002=A1),--('[master] sheet1'!F2:F60
02=B1),'[master]sheet1'!G2:G6002)

Frank


Hello from Steved

The formula below is what I am using which does what I
want in my workbook.
Question E2:E6002, F2:6002, G2:G6002 I would like it to
look in master.xls as the source, as I want to target it
to the workbook that I am in. ie 005.xls

SUMPRODUCT(--(E2:E6002=A1),--(F2:F6002=B1),G2:G6002)

Thankyou
Click to expand...


.
Click to expand...
 
Back
Top