Consulting

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

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

  2. Sticky Thread Sticky: This Forum

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

  3. 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,224
    Simon Lloyd
    09-14-2015, 04:08 PM Go to last post

  4. 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,219
    BobBarker
    02-25-2011, 12:27 PM Go to last post

  5. 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,936
    rajiv_h
    06-17-2020, 04:25 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,969
    Victor
    11-25-2009, 11:46 AM Go to last post

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

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

  3. [SOLVED:] Product if...

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

  4. Sleeper: Calculating Percentages

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

  5. [SOLVED:] Ok, what am i doing wrong in this one?

    Started by slang, 08-23-2012 07:28 AM
    1 Attachment(s)
    • Replies: 10
    • Views: 25,154
    slang
    08-27-2012, 05:32 AM Go to last post

  6. Sleeper: Is .FormulaArray limited to Range?

    Started by skulakowski, 07-19-2011 02:56 PM
    • Replies: 2
    • Views: 5,818
    skulakowski
    07-25-2011, 01:26 PM Go to last post

  7. [SOLVED:] .FormulaArray entry limited to 256 character equation??

    Started by skulakowski, 03-09-2012 07:51 AM
    • Replies: 1
    • Views: 6,298
    Bob Phillips
    03-10-2012, 09:10 AM Go to last post

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

  9. [SOLVED:] Sumproduct using LEFT text from another worksheet?

    Started by Simon Lloyd, 08-03-2010 08:45 AM
    2 Pages •
    1 2
    3 Attachment(s)
    • Replies: 23
    • Views: 21,418
    ajn946946
    01-23-2011, 08:09 PM Go to last post

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

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

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

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

  12. [SOLVED:] SumProduct vs GetPivotData

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

  13. [SOLVED:] Create simplified function

    Started by sassora, 01-28-2011 04:41 AM
    • Replies: 5
    • Views: 6,412
    Bob Phillips
    01-28-2011, 04:19 PM Go to last post

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

  15. Sleeper: General SUMPRODUCT/ARRAY Questions

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

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

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

  17. Moved: Sleeper: vba program

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

  18. [SOLVED:] Using Countifs & Weekdays

    Started by RickS650, 05-03-2017 08:36 AM
    excel 2007, vba code
    • Replies: 7
    • Views: 24,722
    RickS650
    05-04-2017, 05:04 AM Go to last post

  19. [SOLVED:] SUMPRODUCT in VBA Code

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

  20. [SOLVED:] Blockbusters Array

    Started by paulked, 06-17-2015 05:19 AM
    2 Attachment(s)
    • Replies: 5
    • Views: 24,117
    ashleyrobbin
    11-15-2015, 05:33 AM Go to last post
Page 1 of 4 1 2 3 ... LastLast

Forum Information and Options

Users Browsing this Forum

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