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
|