Lookup with 2 criteria?

  • Thread starter Thread starter KrisDHolm
  • Start date Start date
K

KrisDHolm

I have a data tab with 3 columns.

A B C
date account $

There are probably 20,000+ rows of data. On a seperate tab I have a
reports tab that totals out the accounts I care about with the date
across the top.

A B C D
1 8/1/09 8/2/09 8/3/09
2account x
3account y


My question is how can I write a formula that totals this out for me
automatically. Currently I sort by date and I have to do a vlookup and
only name a range that has 1 date. I think there is a better way. Help
if we can.
 
Hi,

You could create pivot tables. Drag Date to the column area, Account to
the row area and Amount to the data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top