Hi all,
I would be grateful as usual if I could get some help on two formulas.
I have a sales table arranged by week. In this scenario I have products which arrive into the business at different times. I am trying to figure out one formula to tell me how many units were sold in the first week of sales, and then another to tell me what week the first sale was made ( as illustrated in the table shaded in yellow)
any help would be much appreciated!!
I would be grateful as usual if I could get some help on two formulas.
I have a sales table arranged by week. In this scenario I have products which arrive into the business at different times. I am trying to figure out one formula to tell me how many units were sold in the first week of sales, and then another to tell me what week the first sale was made ( as illustrated in the table shaded in yellow)
any help would be much appreciated!!