Hi All,
Is there a way of referring to a specific column in a named range in a formula?
I have a range named "Database" that is 37 columns wide and a variable # of rows deep. I want to write a formula that finds all instances of a text string in column 5 of "Database and adds up the corresponding values in column 7 - essentially a sumif using co-ordinates to a named range.
Any thoughts?
Cheers,
Jen