General Function Question

  • Thread starter Thread starter aresar
  • Start date Start date
A

aresar

I am creating a Function using SUMPRODUCT in cell 'SHEET 2'!C1

The Function is SUMPRODUCT(True Statment)*('SHEET 1'!A1)
The true statement is just to make sure certain criteria is met an
gives a 1.

The Function in SHEET 1:A1 is SUMPRODUCT(True Statment)*('SHEET 2'!A1)

I know his seems redundant, but the reason I am taking the value fro
SHEET 2 A1 to SHEET 1 A1 is because if the user wants a different valu
in SHEET 1 A1they can just type over the number in SHEET 1 A1. So th
end result in SHEET 2 C1 is going to be the value in SHEET 2 A1 o
whatever the user keys in.

The problem is the function in SHEET 2 C1 is giving me #VALUE.

Is this because it references a value that is coming from the sam
sheet it is on?

Any help would be appreciated
 
Hi
don't use SUMPRODUCT for this. Try in C1
=IF(your condition,'sheet1'A1,"")
and the same in cell A1 on sheet 1
 
Back
Top