I am having an issue figureing out how to make this work...
Lets say I have a spreadsheet of data.
Type Amounts--------------
A 244 767 567
A 100 100 100
B 40 123 243
Totals
A 344 867 667
B 40 123 243
How would I get the A's to total at the bottom. There can be multiple A's throughout a very large list of data. Normally if it was only one row of A's I would use a vlookup. How can you get that functionality with more than one row???
Any help is greatly appriciated...
Thank you
RAH![]()
Bookmarks