Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif or sumproduct using a date range and another criteria
On Jan 11, 2:21*pm, "T. Valko" wrote:
Try this: =SUMPRODUCT(--(B4:B400="Violation"),--(MONTH(J4:J400)=1),--(YEAR(J4:J400)=2*008)) -- Biff Microsoft Excel MVP "michaelberrier" wrote in message ... I've been through about two dozen threads but cannot find the specific solution I need, so here goes. I need to count how many times a particular occurence (we'll say "Violation" and it is listed in range B4:B400) occurred in January of last year (listed in range J4:J400) *I've tried putting two Sumproduct criteria together and I've tried modified countifs, but neither will work with both criteria in my current form. I appreicate any help.- Hide quoted text - - Show quoted text - Absolutely perfect! Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif or sumproduct using a date range and another criteria
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "michaelberrier" wrote in message ... On Jan 11, 2:21 pm, "T. Valko" wrote: Try this: =SUMPRODUCT(--(B4:B400="Violation"),--(MONTH(J4:J400)=1),--(YEAR(J4:J400)=2*008)) -- Biff Microsoft Excel MVP "michaelberrier" wrote in message ... I've been through about two dozen threads but cannot find the specific solution I need, so here goes. I need to count how many times a particular occurence (we'll say "Violation" and it is listed in range B4:B400) occurred in January of last year (listed in range J4:J400) I've tried putting two Sumproduct criteria together and I've tried modified countifs, but neither will work with both criteria in my current form. I appreicate any help.- Hide quoted text - - Show quoted text - Absolutely perfect! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
Countif with date range criteria | Excel Worksheet Functions | |||
How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
SumProduct/CountIf dilemna + Date Range | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions |