Hold on there just a second!

I think I may have misunderstood what you want.

You just want the total sum of amounts?

Biff

"Biff" wrote in message
...
Like I said, it can be done with formulas but it's complicated.

How many rows of data are there? If there are 1000's of rows, using
formulas isn't very efficient.

Biff

"KC2006" wrote in
message ...

That works for me to see it on the current sheet. What if I have
another sheet I want the data returned to??? Sort of like doing a
VLOOKUP, but returning the sum of the lookups.


--
KC2006
------------------------------------------------------------------------
KC2006's Profile:
http://www.excelforum.com/member.php...o&userid=35391
View this thread:
http://www.excelforum.com/showthread...hreadid=551661