Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INDIRECT Help
Hi
I need to use INDIRECT but Im not sure how.... =SUMPRODUCT(--(TRANSMISSION!$C$6:$IV$6="Foo")*(--(TRANSMISSION!$C$18:$IV$18="Boo"))*(TRANSMISSION!$ C$32:$IV$32)) The 32 is the value of row(A1)+18 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
indirect formula | Excel Worksheet Functions | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
Indirect another wookbook | Excel Worksheet Functions | |||
Using Indirect & Creating a worksheet Macro | Excel Worksheet Functions |