Stock counter.

%3CLINGO-SUB%20id%3D%22lingo-sub-1740922%22%20slang%3D%22en-US%22%3EStock%20counter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1740922%22%20slang%3D%22en-US%22%3EI'm%20struggling%20to%20get%20the%20right%20formula%20and%20after%20some%20help.%20I%20am%20counting%20stock%20sold%20by%20the%20month.%20The%20sold%20date%20is%20in%20column%20H%20in%20DD%2FMM%2FYYYY%20format%20and%20the%20stock%20sold%20on%20that%20date%20is%20in%20column%20J.%20I%20want%20the%20formula%20to%20add%20up%20all%20stock%20sold%20on%20different%20dates%20in%20September%20for%20example.%20Hope%20that%20makes%20sense%20to%20someone.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1740922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1741470%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20counter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1741470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F818374%22%20target%3D%22_blank%22%3E%40Peteeyres%3C%2FA%3E%26nbsp%3B%2C%2C%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EI%20would%20like%20to%20suggest%20two%20possible%26nbsp%3Bformula%2Ffunction%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUMPRODUCT(--(A2%3AA25%26gt%3B%3DDATE(2020%2C9%2C1))*(A2%3AA25%26lt%3B%3DDATE(2020%2C9%2C30))*(D2%3AD25))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUMIFS(D2%3AD25%2CA2%3AA25%2C%22%26gt%3B%3D09%2F01%2F2020%22%2CA2%3AA25%2C%22%26lt%3B%3D09%2F30%2F2020%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWhere%20Column%20A%20has%20Dates%2C%20and%20Column%20D%20has%20Stocks.%3C%2FLI%3E%3CLI%3EAdjust%20cell%20references%20in%20the%20formula%20as%20needed.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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.