Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct
Hi All,
Is there a way to look at a date and only use the month in the criteria. I was trying to use the code below Thanks for any help =SUMPRODUCT((tblProcessorActivity!B1:B30000="CG")* (MONTH(tblProcessorActivity!C1:C30000)=MONTH(MAX(t blProcessorActivity!C:C)))*(tblProcessorActivity!N 1:N30000=4),tblProcessorActivity!D1:D30000) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
=SUMPRODUCT | Excel Discussion (Misc queries) |