|
|
#1
09-17-2015, 03:39 PM
|
|||
|
|||
Indirect AND OR Formula Help
Hi there,
Its my first post, plz take it easy  I've inherited a spread sheet and am struggling to make a change to the formula. =SUMIFS(INDIRECT("'"&COLUMNS($B$1:B1)&"'!$I$11:$I$ 900"),INDIRECT("'"&COLUMNS($B$1:B1)&"'!$C$11:$C$90 0"),$E3,INDIRECT("'"&COLUMNS($B$1:B1)&"'!$F$11:$F$ 900"),$D3, INDIRECT("'"&COLUMNS($B$1:B1)&"'!$G$11:$G$900"),$B 3) Basically, at the moment in the above all three criteria's are AND. However, I want (D3 OR E3) AND B3, I hope that makes sense. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Indirect Reference?
|
tinfanide | Excel | 2 | 08-28-2015 05:11 PM |
| Confusion on INDIRECT function | thatgirlaudrey | Excel | 4 | 06-06-2014 09:23 PM |
|
Indirect Formula with dynamic rows
|
bluionz | Excel | 1 | 03-13-2014 11:00 AM |
| Filter indirect dependencies | SirPercival | Project | 1 | 07-04-2012 01:03 PM |
| Indirect | zleyphox | Excel | 1 | 02-11-2010 09:57 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode