| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT - Count Previous Month
=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. |
| 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 | |||
Threaded Mode
