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