Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help please-SUMPRODUCT and Dynamic Range | Excel Worksheet Functions | |||
SUMPRODUCT between date range | New Users to Excel | |||
Growing range within a Sumproduct. | Excel Worksheet Functions | |||
Sumproduct with #N/A in range | Excel Worksheet Functions | |||
sumproduct in a range | Excel Worksheet Functions |