I have the array formula:

=SUM(IF((Sheet1!$Y1:$Y5809="26")*(Sheet1!$AJ1:$AJ5 809=CREDIT!$A4),1,0))

It works fine except I want it to reference the cell that the number 26
is in rather than having to have it in quotes, i tried this, but don't
get the same answers as this way. The reason being is more conditions
may be added in the future which would mean for example the 26 could
change to a 34 etc so i rather not have to have someone manually change
that number in the formula and just have it refence a cell.

Thanks.


--
vect98
------------------------------------------------------------------------
vect98's Profile: http://www.excelforum.com/member.php...o&userid=26365
View this thread: http://www.excelforum.com/showthread...hreadid=469366