Hi,
So what I am trying to accomplish is Cell B1-D1 is the dates 9/25/17-9/27/17. A5-A15 are my vendors listed B5 is where I would like to start inputting information. What I am trying to do is make a formula that looks up to a table on tab 2 (A3 "Vendor Name", B3 "Expense Category",C3 "invoice amount", D3 "Due Date") that will sum the expense categories related to the descriptions in the "A" Column and also by the date they are due (so a look up with a sum if with B1 as the cell with the date in it.) Thanks for any assistance. I cannot post attachments; apologies.
So what I am trying to accomplish is Cell B1-D1 is the dates 9/25/17-9/27/17. A5-A15 are my vendors listed B5 is where I would like to start inputting information. What I am trying to do is make a formula that looks up to a table on tab 2 (A3 "Vendor Name", B3 "Expense Category",C3 "invoice amount", D3 "Due Date") that will sum the expense categories related to the descriptions in the "A" Column and also by the date they are due (so a look up with a sum if with B1 as the cell with the date in it.) Thanks for any assistance. I cannot post attachments; apologies.
