address formula

  • Thread starter Thread starter xtrmhyper
  • Start date Start date
X

xtrmhyper

on SHEET1 A1 I HAVE A FORMULA
=SUMPRODUCT(--(B1:B9999=X)

on SHEET2 A1 I HAVE A
,--(C1:C9999=O))


HOW CAN I LINK THIS TWO SHEET,
IF CHANGE THE DATA ON SHEET2 A1
LIKE THIS>>> ,--(C1:C9999=P))

THE FORMULA OF SHEET1 A1
WILL BE >>>>
=SUMPRODUCT(--(B1:B9999=X),--(C1:C9999=P))


TNX IN ADVANCE
GOD SPEE
 
I don't think you can do that. The closest you can get is

=SUMPRODUCT(--(B1:B9999=X),--(INDIRECT(Sheet2!A1=P))

where SHEET2 A1 has C1:C9999
 
Back
Top