in B19
=SUMIF(A$2:A$15,A19,B$2:B$15)
and copy down
in B19
=SUMIF(A$2:A$15,A19,B$2:B$15)
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks a million guys cant believe i spent so much time on the VLOOKUP Thanks again much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks