View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Find all 6/1/2007 in the Workbook, Sum Corresponding Dollar Figure

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