GOOGLE SHEETS: Counting total number of rows in the previous month

[mdsurf]

Hi! I'm trying to calculate the total number of rows that exist in the previous month based on the current date.

Here is an example

Date	Submission
1/12/2021	Submission 1
12/27/2020	Submission 2
12/13/2020	Submission 3
11/20/2020	Submission 4
11/03/2020	Submission 5

Since we are currently in the month of january, I would like to know how many submissions there were in the month of December. When we get to February, I would like to calculate the total rows for January.

Is there an equation that can do this? If it makes any difference, I'll be using google sheets.

Thank you!

 

[Toadstool]

Hi MDSurf,

Does this work for you?

MDSurf.xlsx
	A	B	C	D
1	Date	Submission		Result
2	1/12/2021	Submission 1		2
3	12/27/2020	Submission 2
4	12/13/2020	Submission 3
5	11/20/2020	Submission 4
6	11/3/2020	Submission 5
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTIFS($A$2:$A$9999,">="&EOMONTH(TODAY(),-2)+1,$A$2:$A$9999,"<="&EOMONTH(TODAY(),-1))

 

[maabadi]

This formula work For all month except Jan.

=SUMPRODUCT(--(MONTH(I2:I9)=MONTH(TODAY())-1)*(J2:J9))

 

[maabadi]

Try this:

=SUMPRODUCT(--(MONTH(A2:A9)=IF(MONTH(TODAY())=1,12,MONTH(TODAY())-1))*(B2:B9))

Mail Generator2.xlsm
	A	B	C	D	E
1	Date	Start Time
2	12/7/2020	45			45
3	1/12/2021	56
4	1/12/2021	67
5	1/13/2021	78
6	1/14/2021	89
7	1/8/2021	100
8	1/13/2021	111
9	1/14/2021	122
PL2001

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT(--(MONTH(A2:A9)=IF(MONTH(TODAY())=1,12,MONTH(TODAY())-1))*(B2:B9))

Named Ranges
Name	Refers To	Cells
'PL2001'!Extract	='PL2001'!$A$2:$A$2	E2