View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FirstVette52 FirstVette52 is offline
external usenet poster
 
Posts: 37
Default 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