Hi all!
I'm a newbie using MS Excel 2003
I looked through the forums for help, but could not find something specific enough, so I am posting!
I need to populate a 2 dimensional chart that has types of expenses and weeks (please see tab "CF" on attached file) with the SUM of said expenses. The expenses are to be found in the second tab ("Expenses").
I tired to use a SUMIF with AND and 2 VLOOKUPs, e.g.
=SUMIF(Expenses!$B$2:$D$17,AND(VLOOKUP(CF!$A5,Expenses!$B$2:$D$17,3),VLOOKUP(CF!B$1,Expenses!$B$2:$D$17,2))) but it did not do the trick.
Attached is the file, I hope you can help me out!
Thanks in advance,
GP
Bookmarks