Consulting

  1. Announcement:
    Happy birthday VBAX for May
    Aussiebear (Moderator)
    04-06-2024
    Views:
    2,347
Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Threads 21 to 40 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 1

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

  2. 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: 38,617
    rajiv_h
    06-17-2020, 04:25 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: 34,541
    BobBarker
    02-25-2011, 12:27 PM Go to last post

  4. Sticky Thread Sticky: SUMPRODUCT forum

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

  5. Sticky Thread Sticky: This Forum

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

  1. [SOLVED:] SUMIFS help please

    Started by blackie42, 06-15-2017 12:42 PM
    • Replies: 2
    • Views: 17,263
    Bob Phillips
    07-26-2017, 06:02 AM Go to last post

  2. [SOLVED:] SUMPRODUCT in VBA Code

    Started by Philcjr, 03-17-2008 06:47 AM
    • Replies: 2
    • Views: 15,988
    Philcjr
    03-18-2008, 06:26 AM Go to last post

  3. [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,301
    Bob Phillips
    09-24-2009, 11:41 AM Go to last post

  4. [SOLVED:] Sum divide

    Started by benong, 01-01-2011 09:27 PM
    • Replies: 7
    • Views: 14,360
    Paul_Hossler
    01-16-2011, 11:26 AM Go to last post

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

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

  6. [SOLVED:] "Calculating Cells" taking way too long due to SumProduct

    Started by Saladsamurai, 09-28-2009 05:46 AM
    • Replies: 8
    • Views: 12,069
    Tinbendr
    05-23-2010, 06:06 PM Go to last post

  7. Sleeper: General SUMPRODUCT/ARRAY Questions

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

  8. [SOLVED:] Sumproduct/Subtotal > issue

    Started by paddysheeran, 01-19-2022 12:33 PM
    4 Attachment(s)
    • Replies: 13
    • Views: 10,306
    paddysheeran
    01-28-2022, 02:45 AM Go to last post

  9. [SOLVED:] Get Unique days per MD per patient

    Started by Victor, 12-20-2011 11:52 AM
    3 Attachment(s)
    • Replies: 9
    • Views: 9,701
    shrivallabha
    12-24-2011, 09:50 PM Go to last post

  10. [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,520
    Simon Lloyd
    04-11-2009, 03:29 PM Go to last post

  11. [SOLVED:] A job for SP?

    Started by p45cal, 10-21-2011 04:51 PM
    4 Attachment(s)
    • Replies: 8
    • Views: 8,878
    p45cal
    10-27-2011, 03:56 AM Go to last post

  12. [SOLVED:] And vs Or and Not Conditions

    Started by Opv, 06-11-2012 10:56 AM
    • Replies: 7
    • Views: 8,853
    Opv
    06-13-2012, 09:04 AM Go to last post

  13. [SOLVED:] Comparing a range against a range

    Started by fredlo2010, 06-29-2012 05:49 PM
    • Replies: 6
    • Views: 8,477
    fredlo2010
    07-04-2012, 08:48 PM Go to last post

  14. [SOLVED:] Calculate Revenue Based on Date Periods

    Started by Shred Dude, 03-11-2011 12:59 PM
    2 Attachment(s)
    • Replies: 5
    • Views: 8,067
    Shred Dude
    03-12-2011, 09:32 AM Go to last post

  15. [SOLVED:] SumProduct vs GetPivotData

    Started by Shred Dude, 08-18-2011 08:05 AM
    • Replies: 2
    • Views: 7,220
    Shred Dude
    08-23-2011, 09:51 PM Go to last post

  16. Sleeper: Sumproduct Lessons

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

  17. [SOLVED:] Sumproduct result displays incorrectly on sheet

    Started by Shred Dude, 03-11-2011 12:03 AM
    • Replies: 4
    • Views: 7,047
    Shred Dude
    03-11-2011, 10:12 AM Go to last post

  18. [SOLVED:] Product if...

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

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

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

  20. Unhappy [SOLVED:] Lookup problem

    Started by Bazza, 09-29-2009 03:26 AM
    • Replies: 6
    • Views: 6,766
    Saladsamurai
    10-01-2009, 10:22 AM Go to last post
Page 2 of 4 FirstFirst 1 2 3 4 LastLast

Forum Information and Options

Users Browsing this Forum

There are currently 9 users browsing this forum. (0 members & 9 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