| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF - 2 conditions - with references
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| SUMIF based on two conditions | Excel Worksheet Functions | |||
| SUMIF with two conditions | Excel Discussion (Misc queries) | |||
| sumif with two conditions | Excel Worksheet Functions | |||
| SUMIF based on 2 conditions | Excel Worksheet Functions | |||
Threaded Mode
