I need help with excel. I am trying to calculate number on individual product type sold per month and then enter total sold in month onto a table.
I have 1 worksheet showing orders – date of order, product order and quantity but I need to get the sum of each product as a total per month into my Product Table sheet.
I have tried various options but cannot get it to work.
Sorry if this seems a simple question but it is driving me crazy trying to figure it out. As you can guess I am not a excel wizard.
Thanks for your help!