SUMPRODUCT in a range

[FirstVette52]

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

 

[Barb Reinhardt]

IIRC, this may not work for ranges defined with an offset. If I'm wrong, I'm
sure someone will correct me.

 

[Herbert Seidenberg]

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.