Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Having 'brain freeze' with sumproduct...my formula is:
=SUMPRODUCT(--L2:L306=$L309)--(N2:N306=N$308) column 'L' is a list of departments (and I can list as either numeric or alpha) Column 'N" is dates What I want is a the number of times the department matches the date in N$308 (all dates are in date format). The 'value' error appears to be in the dates. |
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 | |||
Do I need SUMPRODUCT? | Excel Worksheet Functions | |||
Sumproduct(N and -- | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) |