I forgot to mention that *both* forms will simply bypass any cells with
non-numeric data in Column B.
This also leaves you open to incorrect returns, but without any means of
notification.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
We can now talk about the different forms of the SumProduct() function.
You'll get a #VALUE! error with the asterisk form (what I suggested), if
*any* of the values in (Column C), are *not* numeric.
You might consider this something "good" or something "bad",
"Good", in that you now know that you have contaminated, or in the least,
"different" data.
"Bad" in that you don't have a viable return.
You might try the unary (comma) version, which will bypass the "bad"
(different) data, and give you a return, HOWEVER, without informing you of
the presence of this "different" data in your list, and therefore *perhaps*
returning *incorrect* solutions.
=SUMPRODUCT(--(B4:B40>=111),--(B4:B40<=120),C4:C40)
It's your choice as to whether or not you need or want to know of the
presence of this "different " data.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
RD,
I did try them and verbatim.... I got Value errors so I assumed that I had
miscommunicated my intent and that for whatever reason that it wouldn't
work.
I am also rather new to the full capabilities of Excel and when I see 2
sets
of parentheses next to each other I assumed they would be multiplied.
I will give them another try and I appreciate your input
Thanks,
Steve