| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT - Count Previous Month
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: =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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT - Count Previous Month
I get the #VALUE! value in that cell.
"Marcelo" wrote in message ... 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: =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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I extract name of the LONG MONTH from previous cell. | Excel Worksheet Functions | |||
| Count Mondays worked in Month | Excel Worksheet Functions | |||
| Match Last Occurrence of Numeric Value and Count BACK to Previous | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
Hybrid Mode
