SUMPRODUCT in a range

  • Thread starter Thread starter FirstVette52
  • Start date Start date
F

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
 
IIRC, this may not work for ranges defined with an offset. If I'm wrong, I'm
sure someone will correct me.
 
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.
 
Back
Top