sgodschalk wrote:
I have a worksheet that holds all of our daily transactions over the last 5
years. Been using just basic Pivots and charts until now. But I need I need
something more complex. The TransactionsDB range an sheet 1 holds a date in
the first column ie 6/1/2009. The breakdown of tender is in the next columns
ie "Cahs", Visa" so on and so forth.
In a separate worksheet, sheet 2, column A holds a date in a format of
6-2009. In Column B I need to query and subtotal all the "Cash" (column "C"
in the TransactionsDB range) transactions for the given month.
I have tinkered with Sumif, vlookup and all sorts of different formulas and
I cannot get it to work on my own...can you help?
Try SUMPRODUCT. See if this helps:
http://www.contextures.com/xlFunctio...tml#SumProduct