Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array Function Question
I am new to these forums, but comfortable with Excel generally. I just discovered the Array functions, and am trying to figure out why the following calculation doesn't work: {=IF(C20:C30="C",$A20:$A30, "")} Basically, if the entry in one of the cells in C column has "C", I want the corresponding cell from the A column. The formula works if the *first* cell in the range is "C"; otherwise, it doesn't. I am sure that this is a simple fix. Can someone fill me in? TIA, David -- sunfish62 ------------------------------------------------------------------------ sunfish62's Profile: http://www.excelforum.com/member.php...o&userid=24541 View this thread: http://www.excelforum.com/showthread...hreadid=381356 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Help with an array function | New Users to Excel | |||
Array Function Question | Excel Worksheet Functions | |||
HLookup? or an array function?? | Excel Worksheet Functions | |||
Dynamic Function Reference Question | Excel Discussion (Misc queries) |