Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,180
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help please-SUMPRODUCT and Dynamic Range Tasha Excel Worksheet Functions 11 July 18th 07 07:28 PM
SUMPRODUCT between date range Celia New Users to Excel 1 November 9th 06 07:39 PM
Growing range within a Sumproduct. mmartens12 via OfficeKB.com Excel Worksheet Functions 5 August 2nd 06 12:46 AM
Sumproduct with #N/A in range Deeds Excel Worksheet Functions 7 May 18th 06 06:01 PM
sumproduct in a range Tat Excel Worksheet Functions 9 June 12th 05 08:31 PM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"