Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
I am using the formula below and it seems to work fine.
As an array: =SUMPRODUCT(--('Enroll I'!$O$2:$O$2741="Regular"),--('Enroll I'!$F$2:$F$2741Q1),--('Enroll I'!$N$2:$N$2741="No Planned Data")) When I check the calculations on the source sheet using AutoFilter, the numbers don't agree. When I remove the second condition, -('Enroll I'!$F$2:$F$2741Q1) It works and the Autofilter comes up with the same number as the calculation. Q1 is a date, so I am asking for those later than this date. Is the Autofilter the problem or the formula? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct help | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT? | Excel Worksheet Functions |