Forum Discussion
Help with finding values in an array
Hey guys,
In the blue highlighted cells in column B, I have different products.
What I want to do, is whenever column B has product 1 for orders 1-30, then I want it to sum the production per month for all the rows where Product 1 is produced, and where product 2 will be produced, etc.
Is anyone able to help on this?
Sagar
3 Replies
And the output to go onto rows 13 to 23, so basically I can calculate total production per month.
in which cell do you want your output?
so the outputs will go from cells g13 to bn23
