invoiced

Hi, I require a formula to match Day, SO Number & product Code to return invoiced Weight? Thank you <tbody> Day SO Number Product Code Invoiced Weight Day SO Number Product Code Invoiced Weight 29/01/2019 SO-291420 26102 19040 30/01/2019 SO-293830 20502 ?? 30/01/2019 SO-292253 10400...

Hi there, I have inserted the following formula and it hasn't worked. It is fairly straightforward in that if cell Y3 had either "Invoiced" or "Part Invoiced" input then return the value in cell W3, otherwise return zero. =IF(Y3="Invoiced"(AND(OR(Y3="Part Invoiced",W3,0)))) Any help would be...

Good day! I have an Excel workbook that I am tracking labor costs, committed and actual. For the actual costs, I am using the "sumbycolor" code and it works great. I need to be able to also create a formula based on cell color and date range. So, I think I need to use a "sumifs" with a...

Hi, I have group of tickets that are in different statuses. For example: 2018-06-21T13:02:19.639 -> Accepted For me I am interested only in the Accepted and Invoiced data and have it linked to SKU. I want to have those cells with the accepted or invoiced information, matched by SKU. I have...

Good morning all. I have a XL query that goes out to our accounting software and pulls these columns: Job1# Job Descr $ Invoiced Job2# Job Descr $ Invoiced Job3# Job Descr $ Invoiced Each of the Jobs has it's own workbook that also has the $ Invoiced amount in it. As...

I'm pretty clueless when it comes to coding and need some help with this excel file. I'm trying to insert a code that will move an entire row from sheet "Ordered" to sheet "Invoiced" when yes is selected from the drop down list in column M. I'd like it to not leave any blank lines on the...

Hi Folks, I am preparing a Projections and Invoiced sheet for Invoicing. I have 2 sheets 1) Project Actuals ($) & 2) Project Projections ($). 1) What I would like to know is that - If my cell text is named as Projected under Project Actuals ($) (F3) it should be able to fetch values from...