| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
problem with Array Formula
I have experienced a problem with an array formula I am combining a SUM(IF) formula with an INDIRECT formula due to the column that is being counted is variable depending on other conditions. Here is the Formula as it reads now {=SUM((IF(INDIRECT(A87&"2:"&RIGHT(A87)&"500")="R1" ,1,0)))} A87 is the cell that references the sheet and column to read. Right now the Cell reads Sheet1!AE The problem lies in that if there is an "R1" in column Sheet1!F it counts that one also! Can anyone help in fixing this error? Thank you -- OrdOff ------------------------------------------------------------------------ OrdOff's Profile: http://www.excelforum.com/member.php...o&userid=22708 View this thread: http://www.excelforum.com/showthread...hreadid=383550 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula not working | Excel Worksheet Functions | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| How to add in an array formula if iisna index match | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Threaded Mode
