Text Query


Posted by Lee Hitchen on November 06, 2001 5:23 AM

Has anyone a solution for aggregating values based on selected text meeting a given criteria? For example say I have 4 locations detailed in cells A1:A4 (tokyo east, tokyo west, tokyo south & Korea. I wish to add the corresponding values in b1:b4 where cells a1:a4 contain like values.

Tahnks for you help



Posted by Mark W. on November 06, 2001 6:13 AM

What constitutes a "like value"? (nt)