| 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 |
| 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 | |||
Threaded Mode
