Formula problem
Biff would have meant to post the below
=SUMPRODUCT(($B$6:$B$417<DATE(2009,10,1))*($Q$6:$Q $417=B463)
*ISNUMBER($D$6:$O$417),$D$6:$O$417)
If this post helps click Yes
---------------
Jacob Skaria
"Joe User" wrote:
"T. Valko" wrote:
Try it like this...
[....]
=SUMPRODUCT(($B$6:$B$417<DATE(2009,10,1))*($Q$6:$Q $417=B463)*$D$6:$O$417)
Note that if there's any TEXT in the range $D$6:$O$417 you'll get an
error.
..... Which we can avoid by using something like the original form, namely:
=SUMPRODUCT(($B$6:$B$417<DATE(2009,10,1))*($Q$6:$Q $417=B463),$D$6:$O$417)
Since the OP was complaining of #VALUE errors, I don't see why you would
steer him in a direction that might exacerbate the problem.
----- original message -----
"T. Valko" wrote in message
...
Try it like this...
Just a normal ENTER will do. No need to array enter.
=SUMPRODUCT(($B$6:$B$417<DATE(2009,10,1))*($Q$6:$Q $417=B463)*$D$6:$O$417)
Note that if there's any TEXT in the range $D$6:$O$417 you'll get an
error.
--
Biff
Microsoft Excel MVP
"mjones" wrote in message
...
Hi All,
Here's another I hope you can help with.
Here's my formula that works fine:
{=SUMPRODUCT(--($B$6:$B$417<DATE(2009,10,1)),--($Q$6:$Q$417=B463),$D
$6:$D$417)}
Now I want to change the end to ,$D$6:$O$417)}, but changing the D to
an O gives the old #VALUE!.
I don't suspect the cells in the formula because I'm using them with
other similar formulas.
Any help would be appreciated.
Thanks,
Michele
.
|