Hi all,

Let say, Names in Column A such as ABC 01, ABCD 001, XY 0001 and so
on....the names can be varies in length, but we can identify by the group
name, like ABC xxx, XY xxx ...etc and in Column D, I have Code like US, CA,
GB for the corresponding rows and in column B, I have amount for related to
each names.

If the total sum of the amount in a particular group, eg. all the names
under ABC and code under "US", is less than 100, put a "N" in Column C of the
corresponding rows, otherwise put a "Y" if the amount is greater than 100.