Consulting

  1. Announcement:
    Happy birthday VBAX for May
    Aussiebear (Moderator)
    04-06-2024
    Views:
    1,519
Page 3 of 4 FirstFirst 1 2 3 4 LastLast
Threads 41 to 60 of 61

Forum: SUMPRODUCT And Other Array Functions

A forum to help the understanding of SUMPRODUCT and array functions. Powered by XLD.

  1. Sticky Thread Sticky: SUMPRODUCT Step By Step - Part 3

    Started by Bob Phillips, 05-12-2009 03:49 PM
    2 Attachment(s)
    • Replies: 14
    • Views: 37,384
    rajiv_h
    06-17-2020, 04:25 PM Go to last post

  2. Sticky Thread Sticky: SUMPRODUCT Step By Step - Part 1

    Started by Bob Phillips, 04-12-2009 01:16 PM
    2 Pages •
    1 2
    1 Attachment(s)
    • Replies: 22
    • Views: 63,490
    Simon Lloyd
    09-14-2015, 04:08 PM Go to last post

  3. Sticky Thread Sticky: SUMPRODUCT Step By Step - Part 2

    Started by Bob Phillips, 04-19-2009 10:44 AM
    1 Attachment(s)
    • Replies: 7
    • Views: 33,953
    BobBarker
    02-25-2011, 12:27 PM Go to last post

  4. Sticky Thread Sticky: This Forum

    Started by Bob Phillips, 04-11-2009 02:43 PM
    • Replies: 0
    • Views: 19,206
    Bob Phillips
    04-11-2009, 02:43 PM Go to last post

  5. Sticky Thread Sticky: SUMPRODUCT forum

    Started by Zack Barresse, 04-11-2009 01:40 PM
    • Replies: 0
    • Views: 22,203
    Zack Barresse
    04-11-2009, 01:40 PM Go to last post

  1. [SOLVED:] Sumproduct/Array formula for cells with date

    Started by Victor, 11-24-2009 04:46 PM
    • Replies: 4
    • Views: 6,958
    Victor
    11-25-2009, 11:46 AM Go to last post

  2. Sleeper: Calculating Percentages

    Started by Slicemahn, 11-15-2009 11:31 PM
    • Replies: 1
    • Views: 4,828
    Bob Phillips
    11-16-2009, 01:47 AM Go to last post

  3. Advice: Sorting and Filtering with Array Formulas

    Started by mikerickson, 04-26-2009 09:59 PM
    • Replies: 2
    • Views: 5,914
    arkusM
    11-04-2009, 09:36 AM Go to last post

  4. Sleeper: Sumproduct Lessons

    Started by Juba, 06-15-2009 11:28 PM
    • Replies: 7
    • Views: 7,020
    Bob Phillips
    10-23-2009, 05:36 AM Go to last post

  5. Unhappy [SOLVED:] Lookup problem

    Started by Bazza, 09-29-2009 03:26 AM
    • Replies: 6
    • Views: 6,718
    Saladsamurai
    10-01-2009, 10:22 AM Go to last post

  6. Sleeper: General SUMPRODUCT/ARRAY Questions

    Started by Saladsamurai, 09-24-2009 11:51 AM
    • Replies: 6
    • Views: 10,317
    Saladsamurai
    09-25-2009, 08:11 AM Go to last post

  7. [SOLVED:] Is this a job for SUMPRODUCT? Or is it easier?

    Started by Saladsamurai, 09-23-2009 10:05 AM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 25
    • Views: 15,249
    Bob Phillips
    09-24-2009, 11:41 AM Go to last post

  8. [SOLVED:] Sumproduct forumla needed for complex sum.

    Started by DocBrown, 09-16-2009 06:16 PM
    1 Attachment(s)
    • Replies: 4
    • Views: 6,022
    Benzadeus
    09-22-2009, 07:19 AM Go to last post

  9. [SOLVED:] Sumproduct short question - count in sumproduct

    Started by danovkos, 09-04-2009 01:44 AM
    1 Attachment(s)
    • Replies: 5
    • Views: 6,119
    danovkos
    09-04-2009, 04:38 AM Go to last post

  10. Sleeper: 2 Sumproduct Function same result

    Started by hardeep, 07-09-2009 12:58 AM
    • Replies: 5
    • Views: 6,246
    Zack Barresse
    07-16-2009, 01:32 PM Go to last post

  11. Moved: Highlight cells which have no dependents

    Started by Ali-imran, 07-23-2013 10:47 AM
    •  
    •  

  12. [SOLVED:] Help with sumproduct function

    Started by Digita, 05-11-2009 06:40 PM
    1 Attachment(s)
    • Replies: 3
    • Views: 4,879
    Digita
    05-12-2009, 05:20 PM Go to last post

  13. Moved: Advice: Redefine type of variable

    Started by obivan, 07-23-2013 10:47 AM
    •  
    •  

  14. [SOLVED:] Average of Values in Column E for each value in Column B - help

    Started by Foxtrot, 04-25-2009 09:54 AM
    1 Attachment(s)
    • Replies: 4
    • Views: 5,244
    Aussiebear
    04-25-2009, 10:56 AM Go to last post

  15. [SOLVED:] SUMPRODUCT (or array formula?) question

    Started by Benzadeus, 04-21-2009 10:43 AM
    2 Attachment(s)
    • Replies: 16
    • Views: 14,134
    mdmackillop
    04-22-2009, 02:44 PM Go to last post

  16. [SOLVED:] Product if...

    Started by tkaplan, 04-21-2009 12:11 PM
    1 Attachment(s)
    • Replies: 4
    • Views: 6,989
    tkaplan
    04-21-2009, 01:27 PM Go to last post

  17. [SOLVED:] How to use SUMPRODUCT for text offset over a discontiguous range? [Tutorial]

    Started by Simon Lloyd, 04-09-2009 12:31 PM
    • Replies: 8
    • Views: 9,442
    Simon Lloyd
    04-11-2009, 03:29 PM Go to last post

  18. [SOLVED:] SUMPRODUCT help

    Started by lifeson, 04-07-2009 04:33 AM
    1 Attachment(s)
    • Replies: 3
    • Views: 4,978
    Bob Phillips
    04-07-2009, 08:07 AM Go to last post

  19. [SOLVED:] More help with SumProduct

    Started by dragon, 04-06-2009 07:10 AM
    1 Attachment(s)
    • Replies: 6
    • Views: 6,303
    dragon
    04-07-2009, 02:14 AM Go to last post

  20. [SOLVED:] Sumproduct in VBA

    Started by Bazman, 04-07-2009 12:11 AM
    • Replies: 4
    • Views: 27,598
    Bazman
    04-07-2009, 01:33 AM Go to last post
Page 3 of 4 FirstFirst 1 2 3 4 LastLast

Forum Information and Options

Users Browsing this Forum

There are currently 10 users browsing this forum. (0 members & 10 guests)

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 25 replies or 150 views
Hot thread with unread posts
More than 25 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules