SUMPRODUCT in a range
IIRC, this may not work for ranges defined with an offset. If I'm wrong, I'm
sure someone will correct me.
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"FirstVette52" wrote:
For some reason, I cannot get the sumproduct argument to work. I am trying
to add everything where the Parent AGI is between 25,000 and 50,000. This
works when I only use one of the two arguments, but when I combine them, I
get 0.
=SUMPRODUCT(--(Data[[#All],[Parent AGI]]=25000),--(Data[[#All],[Parent
AGI]]<50000),Data[[#All],[TBRACCD_AMOUNT]])
Thanks for any help you may be able to offer
--
FirstVette52
|