Stock counter.

Copper Contributor
I'm struggling to get the right formula and after some help. I am counting stock sold by the month. The sold date is in column H in DD/MM/YYYY format and the stock sold on that date is in column J. I want the formula to add up all stock sold on different dates in September for example. Hope that makes sense to someone.
1 Reply

@Peteeyres ,,,

 

I would like to suggest two possible formula/function:

 

=SUMPRODUCT(--(A2:A25>=DATE(2020,9,1))*(A2:A25<=DATE(2020,9,30))*(D2:D25))

 

=SUMIFS(D2:D25,A2:A25,">=09/01/2020",A2:A25,"<=09/30/2020")

 

  • Where Column A has Dates, and Column D has Stocks.
  • Adjust cell references in the formula as needed.