Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct with 3 variables
Trying to count the # times that 3.25 shows up in rows that meet multiple
criteria. I've got this formula working with 2 variables: =SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16="1001")) But I want to add another and that seems to foul it up (returns 0, instead of the correct count #). My last two criteria are to limit it to within 30 days of a date. Any ideas what I have wrong here? =SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16="1001"),(--($A5-($A$9:$A$16))<30)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple variables in sumproduct or if/then formulas | Excel Worksheet Functions | |||
Too Many Variables | Excel Worksheet Functions | |||
Variables in VBA | Excel Discussion (Misc queries) | |||
Too many variables? | Excel Worksheet Functions | |||
SUM IF and two variables | Excel Worksheet Functions |