I've attached a sample workbook. Basically what I need done is finding "expenses incurred (po amounts) - not received (no invoice yet)" values (this is on sheet2 m1). In workbook, on sheet1 row3, there are five po's listed but only three have invoices (known by whether having a date or invoice number). So, total sub cost is $5 (total po cost) minus the po's that have corresponding invoices gives us $2. On sheet3 row44, is the total sub cost. I really do hope this makes sense, I've got the worksheet filled out but with no formulas. Thanks!
Bookmarks