SUMPRODUCT - Count Previous Month

  • Thread starter Thread starter HearSay
  • Start date Start date
H

HearSay

=SUMPRODUCT((INPUT!$B$2:$B$20000 = A2)*(INPUT!$A$2:$A$20000 =
MONTH(NOW()) -1))

I would like to count the number of records from the previous month
regardless of what month it is.

So if I run this in October, it will check column A, and give me a count of
all the records for September.

I don't think I am doing this correct.
 
try

=sumproduct(--(month(INPUT!$a$2:$a$20000)=(month(now())-1)*(INPUT!$B$2:$B$20000 = A2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"HearSay" escreveu:
 
I get the #VALUE! value in that cell.


Marcelo said:
try

=sumproduct(--(month(INPUT!$a$2:$a$20000)=(month(now())-1)*(INPUT!$B$2:$B$20000
= A2)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"HearSay" escreveu:
 
How about:

=SUMPRODUCT(--(Input!$B$2:$B$20000=A2),
--(TEXT(Input!$A$2:$A$20000,"yyyymm")
=TEXT(TODAY()-DAY(TODAY()),"yyyymm")))

=today()-day(today())
gives the last day of the previous month

9/29/2006 - 29 = Sept 0th, 2006, which is Aug 31, 2006.

And the formatting will ignore the days and just look at the month/year.
 
Back
Top