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 Bob Phillips.

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

    Started by Bob Phillips, 05-12-2009 03:49 PM
    • Replies: 14
    • Views: 44,282
    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
    • Replies: 22
    • Views: 73,809
    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
    • Replies: 7
    • Views: 39,199
    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: 23,824
    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: 27,187
    04-11-2009, 01:40 PM Go to last post
  1. Mismatch for Sumproduct

    Started by mikejo, 09-23-2023 03:31 AM
    • Replies: 4
    • Views: 43,227
    09-23-2023, 07:24 AM Go to last post
  2. [SOLVED:] Sumproduct/Subtotal > issue

    Started by paddysheeran, 01-19-2022 12:33 PM
    • Replies: 13
    • Views: 14,370
    01-28-2022, 02:45 AM Go to last post
  3. [SOLVED:] Sumif not working

    Started by cvilla7174, 04-30-2019 11:34 AM
    • Replies: 2
    • Views: 34,679
    10-27-2021, 02:44 AM Go to last post
    • Replies: 0
    • Views: 23,434
    01-24-2019, 05:20 AM Go to last post
  4. [SOLVED:] Adding two columns together with two criteria

    Started by oam, 03-06-2018 09:28 PM
    • Replies: 3
    • Views: 27,548
    04-22-2018, 03:46 PM Go to last post
  5. [SOLVED:] SUMIFS help please

    Started by blackie42, 06-15-2017 12:42 PM
    • Replies: 2
    • Views: 21,136
    07-26-2017, 06:02 AM Go to last post
  6. [SOLVED:] Using Countifs & Weekdays

    Started by RickS650, 05-03-2017 08:36 AM
    excel 2007, vba code
    • Replies: 7
    • Views: 29,711
    05-04-2017, 05:04 AM Go to last post
  7. [SOLVED:] #VALUE! Error for Single Criterion Sumproduct Function

    Started by khameleon1, 02-23-2017 09:25 AM
    • Replies: 7
    • Views: 27,502
    03-01-2017, 10:09 AM Go to last post
  8. [SOLVED:] #VALUE Error using Sumproduct

    Started by Opv, 06-20-2016 04:27 PM
    • Replies: 5
    • Views: 28,397
    10-04-2016, 04:41 PM Go to last post
  9. Cool [SOLVED:] SUMPRODUCT returning FALSE

    Started by Billy C, 01-27-2014 03:41 AM
    • Replies: 9
    • Views: 32,553
    05-24-2016, 10:51 AM Go to last post
  10. [SOLVED:] Blockbusters Array

    Started by paulked, 06-17-2015 05:19 AM
    • Replies: 5
    • Views: 28,696
    11-15-2015, 05:33 AM Go to last post
    • Replies: 6
    • Views: 29,205
    06-13-2015, 02:50 PM Go to last post
  11. [SOLVED:] Search contents of multiline cells within entire workbook

    Started by john3j, 04-28-2015 11:39 AM
    • Replies: 8
    • Views: 27,757
    05-08-2015, 04:37 AM Go to last post
  12. [SLEEPER:] Conditional count help

    Started by jmenche, 12-04-2014 08:54 AM
    • Replies: 1
    • Views: 22,082
    01-03-2015, 06:14 AM Go to last post
  13. Sleeper: Conditional cumulative sum

    Started by pandres2002, 10-01-2014 06:59 AM
    • Replies: 2
    • Views: 25,459
    12-04-2014, 04:29 PM Go to last post
  14. [SOLVED:] Changing variables in SumProduct formula

    Started by Billy C, 01-28-2014 08:29 AM
    • Replies: 9
    • Views: 30,591
    01-29-2014, 03:33 AM Go to last post
  15. [SOLVED:] Sumproduct instead of countif. 1 digit numbers problem.

    Started by fleskj, 08-05-2013 04:28 AM
    benford's law
    • Replies: 8
    • Views: 27,843
    01-12-2014, 03:16 PM Go to last post
    • Replies: 3
    • Views: 33,144
    09-25-2013, 10:49 PM Go to last post
  16. [SOLVED:] Sumproduct with Variables

    Started by lintthief, 01-30-2013 08:41 AM
    • Replies: 1
    • Views: 25,811
    01-30-2013, 01:44 PM Go to last post
  17. [SOLVED:] Values From A Closed Workbook

    Started by crissy_c, 11-26-2012 06:12 PM
    • Replies: 5
    • Views: 32,002
    11-28-2012, 01:50 AM Go to last post

Forum Information and Options

Moderators of this Forum
Users Browsing this Forum

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