I have 500+ rows of data in column A (Credit), with corresponding data in column B (Cash). I use "=SUM(LARGE(A:A,{1,2,3}))" in C1 to find and sum the three largest "Credit" entries, how do I sum the corresponding cash values associated with those three large credit entries?
Any help would be greatly appreciated!
Bookmarks