Counting Values in a Column If Corresponding Date is in Current Month and Year

[francoiscj1]

Column A: Date (00/00/00)
Column M: Reordered Quantity

Looking for a formula for cell P2. The formula should count the values in column M (Reordered Quantity) if the corresponding date in Column A falls within the current month and year. Thanks!​

 

[sandy666]

as example:

today() =>> 14/01/2019

24/12/18​		222​		15​		=SUMPRODUCT((TEXT($H$3:$H$32,"mm/yy")=TEXT(TODAY(),"mm/yy"))*(COUNT($J$3:$J$32)>0))
25/12/18​		120​
26/12/18​		184​
27/12/18​		155​
28/12/18​		176​
29/12/18​		76​
30/12/18​		112​
31/12/18​		122​
01/01/19​		75​
02/01/19​		174​
03/01/19​		28​
20/01/19​		125​
21/01/19​		143​
22/01/19​		154​
23/01/19​		133​
24/01/19​		20​
25/01/19​		208​
26/01/19​		98​
27/01/19​		114​
28/01/19​		174​
29/01/19​		83​
30/01/19​		62​
31/01/19​		210​
01/02/19​		112​
02/02/19​		60​
03/02/19​		27​
04/02/19​		216​
05/02/19​		112​
06/02/19​		43​
07/02/19​		143​

correct range to your needs

 

[sandy666]

ignore post above - wrong formula.

try: =SUMPRODUCT(--(TEXT($H$4:$H$33,"mm/yy")=TEXT(TODAY(),"mm/yy")))-SUMPRODUCT(--ISBLANK(($J$4:$J$33)))