Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilling using INDIRECT in a formula
I am using a SUMIF formula to total checks received from various
clients. I have a list of clients entered into cells A21:A109 as text. Rather than copying the text contained in those cells into each formula I have attempted to use the INDIRECT function to fill that portion of the argument. Using INDIRECT("A21") within the SUMIF function I can get the fucntion to reference the text in that cell but when I try to auto fill the formula down the cell reference will not change. If anyone has a way to do this I would appreciate the advice. I'm attempting to use: =SUMIF($H$3:$H$6003,INDIRECT("A21"),$O$3:$O$6003) instead of =SUMIF($H$3:$H$6003,'Client Name',$O$3:$O$6003) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilling using INDIRECT in a formula
What is wrong with
=SUMIF($H$3:$H$6003,A21,$O$3:$O$6003) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "BB" wrote in message ups.com... I am using a SUMIF formula to total checks received from various clients. I have a list of clients entered into cells A21:A109 as text. Rather than copying the text contained in those cells into each formula I have attempted to use the INDIRECT function to fill that portion of the argument. Using INDIRECT("A21") within the SUMIF function I can get the fucntion to reference the text in that cell but when I try to auto fill the formula down the cell reference will not change. If anyone has a way to do this I would appreciate the advice. I'm attempting to use: =SUMIF($H$3:$H$6003,INDIRECT("A21"),$O$3:$O$6003) instead of =SUMIF($H$3:$H$6003,'Client Name',$O$3:$O$6003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
vlookup + indirect formula | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Indirect used in an array formula | Excel Worksheet Functions |