I have searched the site and not found an answer that I can apply to my issue.
I have created a
workbook with the help of ascalese, and now I would like to get the total of items ordered and put them in a total
Right now, when an ordered is entered, I create a copy of the worksheet between to sheets (start name
"Orders_Start" and end name "Orders_End").
I am trying to do a SUMIF on all items ordered. Several items are
always in a cell like A19 - A24, and then total them in my total sheet.
I tried the following:
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
And I get "#Value!"
I have several cells that are standard items, so these will be straight forward to
Then next 20 cells below them are Vlookup items from a validation list and I am not sure how to get all
these items and add them to my total list.
Once I do, I can do another SUMIF on this list and get a final
I hope I am being clear enough on this.
Thanks as always,