A few things... You could use a pivot tabel with multiple consolidation
ranges to do what you want. All other solutions are pretty much going to
require you to have the summary sheet (to be effective and manageable). If
you have the summary sheet then you could use sumproduct formulas... Here are
some links for you to look at...

http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"ryguy7272" wrote:

Hello all! I am trying to figure out the very simplest way to do something
very complicated. I am looking for a way to sum up all the dollar amounts
that meet two criteria. For instance, I want to sum all the expenses on
6/1/2007, that fell into category LM, and sum all expenses on 6/1/2007, that
fell into category BD, etc. All together, there are 5 categories (BD, VISIT,
LD1, LM, ADJ, & LD2). This is tricky because it requires a double lookup.
Vlookup doesnt seem to be able to handle the demand. I tried Index/Match
and didnt get the results I was looking for. Can someone offer a better
suggestion as to how to do this? I am ok with VBA, but still learning and I
dont feel like I know where to start with this thing. I think it will
require a VBA solution. Finally, the data is stored on multiple sheets,
titled 6-1, 6-2, 6-3 (days in June). Is there a way to find every incidence
of 6/1/2007 in the workbook, then sum the dollar figures that correspond to
LM, BD, etc? I was thinking of taking all values on all sheets, copying them
to one summary sheet, and then working only with that summary sheet for the
lookup, index/match, find, whatever. Does this make sense? I am open to
literally anything. The workbook that I inherited doesnt work at all so I
am trying to divorce myself from it and start over anyway.

Regards,
Ryan---

--
RyGuy