SUMPRODUCT in a range
 

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

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

SUMPRODUCT in a range
 

Use this format:
=SUMPRODUCT((Table1[BinA]=200)*(Table1[BinA]<300)*Table1[Amt])
Use *, not comma.
A double negative then becomes redundant.
Don't use [#All] unless you want to include the Header and the Total
Row.
A redundant [#Data] is OK.
If there is just one Table, Table1 is redundant.