Consulting

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 Step By Step - Part 1

    Started by Bob Phillips, 04-12-2009 01:16 PM
    2 Pages
    1 2
    • Replies: 22
    • Views: 62,902
    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
    • Replies: 14
    • Views: 36,980
    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
    • Replies: 7
    • Views: 33,717
    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,036
    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: 21,916
    04-11-2009, 01:40 PM Go to last post
  1. [SOLVED] Is this a job for SUMPRODUCT? Or is it easier?

    Started by Saladsamurai, 09-23-2009 10:05 AM
    2 Pages
    1 2
    • Replies: 25
    • Views: 15,182
    09-24-2009, 11:41 AM Go to last post
  2. [SOLVED] Sumproduct using LEFT text from another worksheet?

    Started by Simon Lloyd, 08-03-2010 08:45 AM
    2 Pages
    1 2
    • Replies: 23
    • Views: 21,281
    01-23-2011, 08:09 PM Go to last post
  3. [SOLVED] SUMPRODUCT (or array formula?) question

    Started by Benzadeus, 04-21-2009 10:43 AM
    • Replies: 16
    • Views: 14,041
    04-22-2009, 02:44 PM Go to last post
  4. [SOLVED] Sumproduct/Subtotal > issue

    Started by paddysheeran, 01-19-2022 12:33 PM
    • Replies: 13
    • Views: 9,817
    01-28-2022, 02:45 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
    • Replies: 10
    • Views: 24,697
    08-27-2012, 05:32 AM Go to last post
  6. [SOLVED] Get Unique days per MD per patient

    Started by Victor, 12-20-2011 11:52 AM
    • Replies: 9
    • Views: 9,593
    12-24-2011, 09:50 PM Go to last post
  7. Cool [SOLVED] SUMPRODUCT returning FALSE

    Started by Billy C, 01-27-2014 03:41 AM
    • Replies: 9
    • Views: 26,682
    05-24-2016, 10:51 AM Go to last post
  8. [SOLVED] Changing variables in SumProduct formula

    Started by Billy C, 01-28-2014 08:29 AM
    • Replies: 9
    • Views: 24,725
    01-29-2014, 03:33 AM Go to last post
    • Replies: 8
    • Views: 9,384
    04-11-2009, 03:29 PM Go to last post
  9. [SOLVED] "Calculating Cells" taking way too long due to SumProduct

    Started by Saladsamurai, 09-28-2009 05:46 AM
    • Replies: 8
    • Views: 11,977
    05-23-2010, 06:06 PM Go to last post
  10. [SOLVED] A job for SP?

    Started by p45cal, 10-21-2011 04:51 PM
    • Replies: 8
    • Views: 8,784
    10-27-2011, 03:56 AM Go to last post
  11. [SOLVED] Sumproduct instead of countif. 1 digit numbers problem.

    Started by fleskj, 08-05-2013 04:28 AM
    benford's law
    • Replies: 8
    • Views: 22,291
    01-12-2014, 03:16 PM Go to last post
  12. [SOLVED] Search contents of multiline cells within entire workbook

    Started by john3j, 04-28-2015 11:39 AM
    • Replies: 8
    • Views: 22,726
    05-08-2015, 04:37 AM Go to last post
  13. Sleeper: Sumproduct Lessons

    Started by Juba, 06-15-2009 11:28 PM
    • Replies: 7
    • Views: 6,963
    10-23-2009, 05:36 AM Go to last post
  14. [SOLVED] Sum divide

    Started by benong, 01-01-2011 09:27 PM
    • Replies: 7
    • Views: 14,126
    01-16-2011, 11:26 AM Go to last post
  15. [SOLVED] And vs Or and Not Conditions

    Started by Opv, 06-11-2012 10:56 AM
    • Replies: 7
    • Views: 8,687
    06-13-2012, 09:04 AM Go to last post
  16. [SOLVED] #VALUE! Error for Single Criterion Sumproduct Function

    Started by khameleon1, 02-23-2017 09:25 AM
    • Replies: 7
    • Views: 22,420
    03-01-2017, 10:09 AM Go to last post
  17. [SOLVED] Using Countifs & Weekdays

    Started by RickS650, 05-03-2017 08:36 AM
    excel 2007, vba code
    • Replies: 7
    • Views: 23,960
    05-04-2017, 05:04 AM Go to last post
  18. [SOLVED] More help with SumProduct

    Started by dragon, 04-06-2009 07:10 AM
    • Replies: 6
    • Views: 6,250
    04-07-2009, 02:14 AM Go to last post
  19. [SOLVED] Comparing a range against a range

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

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
  •