I
inquisitor
When I query a datatable using VLOOKUP I get the answer returned fro
the first instance of a name that appears albeit in the correct column
If ABC is in row 2 with a value of 5 and also in row 3 with a value o
6, I get the reult 5 from row 2 in my formula. What I need is for
formula that will sum all instances of the row name ABC so giving m
the answer 11 (5+6). Ideally I don't want to go into VB scripting bu
can handle nesting ormulae. I don't want to use dat>subtotals either a
I need it to work 'behind the scenes'
I am using Excel 2000.
Any help would be gratefully received
the first instance of a name that appears albeit in the correct column
If ABC is in row 2 with a value of 5 and also in row 3 with a value o
6, I get the reult 5 from row 2 in my formula. What I need is for
formula that will sum all instances of the row name ABC so giving m
the answer 11 (5+6). Ideally I don't want to go into VB scripting bu
can handle nesting ormulae. I don't want to use dat>subtotals either a
I need it to work 'behind the scenes'
I am using Excel 2000.
Any help would be gratefully received