Using sumproduct with date function

[trader1990]

I am building inventory report to show how inventory is doing
When I do counts for each day I enter manual data into the excel table i have build
like in first column I have Date of cycle count, next part#, Stock location, physical count, variance value $
I tally all the numbers on a separate table to be more readable
I am having trouble with SUM product function and date range
I want to count how many variances are in a month,
The tables I use are
DATE of cycle count and Variance
in the month of January I have entered 700 lines and each line has a variance of either $0 or $ range in plus (extra stock) and minus (missing stock)
I want to count the variances how many I have done in January , february, march
originally I use this function =SUMPRODUCT(--(LEN(G18:G10000)>0)) and it calculates perfectly the number of variances but now I have data entry for February, March, and April
and this function counts all how can I make this work for each separate month?
all The dates are entered in A23:A10000 and variances are in G18:G10000

 

[trader1990]

Admin Please remove this post I double posted accidentally