Consulting

  1. Announcement:
    Happy birthday VBAX for May
    Aussiebear (Moderator)
    04-06-2024
    Views:
    2,416
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
    1 Attachment(s)
    • Replies: 22
    • Views: 65,175
    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,768
    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,639
    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,843
    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,806
    Bob Phillips
    04-11-2009, 02:43 PM Go to last post

  1. [SOLVED:] Sumif not working

    Started by cvilla7174, 04-30-2019 11:34 AM
    • Replies: 2
    • Views: 29,288
    georgiboy
    10-27-2021, 02:44 AM Go to last post

  2. [SOLVED:] VBA issue: Sumproduct & index and match - multiple criteria

    Started by lars_larsen, 09-25-2013 02:21 AM
    1 Attachment(s)
    • Replies: 3
    • Views: 28,832
    sijpie
    09-25-2013, 10:49 PM Go to last post

  3. Cool [SOLVED:] SUMPRODUCT returning FALSE

    Started by Billy C, 01-27-2014 03:41 AM
    • Replies: 9
    • Views: 27,881
    patcell67
    05-24-2016, 10:51 AM Go to last post

  4. [SOLVED:] Sumproduct in VBA

    Started by Bazman, 04-07-2009 12:11 AM
    • Replies: 4
    • Views: 27,667
    Bazman
    04-07-2009, 01:33 AM Go to last post

  5. [SOLVED:] Changing variables in SumProduct formula

    Started by Billy C, 01-28-2014 08:29 AM
    • Replies: 9
    • Views: 25,837
    Billy C
    01-29-2014, 03:33 AM Go to last post

  6. [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,552
    slang
    08-27-2012, 05:32 AM Go to last post

  7. [SOLVED:] Using Countifs & Weekdays

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

  8. [SOLVED:] Values From A Closed Workbook

    Started by crissy_c, 11-26-2012 06:12 PM
    2 Attachment(s)
    • Replies: 5
    • Views: 25,019
    Bob Phillips
    11-28-2012, 01:50 AM Go to last post

  9. [SOLVED:] Blockbusters Array

    Started by paulked, 06-17-2015 05:19 AM
    2 Attachment(s)
    • Replies: 5
    • Views: 24,470
    ashleyrobbin
    11-15-2015, 05:33 AM Go to last post

  10. Sleeper: Matrix multiplication in VBA (not the application. one)

    Started by amri, 06-09-2015 10:10 AM
    • Replies: 6
    • Views: 24,469
    Paul_Hossler
    06-13-2015, 02:50 PM Go to last post

  11. [SOLVED:] #VALUE Error using Sumproduct

    Started by Opv, 06-20-2016 04:27 PM
    • Replies: 5
    • Views: 24,230
    Opv
    10-04-2016, 04:41 PM Go to last post

  12. [SOLVED:] Search contents of multiline cells within entire workbook

    Started by john3j, 04-28-2015 11:39 AM
    1 Attachment(s)
    • Replies: 8
    • Views: 23,696
    john3j
    05-08-2015, 04:37 AM Go to last post

  13. [SOLVED:] Adding two columns together with two criteria

    Started by oam, 03-06-2018 09:28 PM
    • Replies: 3
    • Views: 23,433
    oam
    04-22-2018, 03:46 PM Go to last post

  14. [SOLVED:] #VALUE! Error for Single Criterion Sumproduct Function

    Started by khameleon1, 02-23-2017 09:25 AM
    2 Attachment(s)
    • Replies: 7
    • Views: 23,370
    Aflatoon
    03-01-2017, 10:09 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: 23,361
    GGGG
    01-12-2014, 03:16 PM Go to last post

  16. [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,491
    ajn946946
    01-23-2011, 08:09 PM Go to last post

  17. Sleeper: Conditional cumulative sum

    Started by pandres2002, 10-01-2014 06:59 AM
    • Replies: 2
    • Views: 21,168
    Zack Barresse
    12-04-2014, 04:29 PM Go to last post

  18. [SOLVED:] Sumproduct with Variables

    Started by lintthief, 01-30-2013 08:41 AM
    • Replies: 1
    • Views: 20,728
    lintthief
    01-30-2013, 01:44 PM Go to last post

  19. Comparing two lists, identifying and highlighting missing entries using MATCH

    Started by mrdgaf, 01-24-2019 05:20 AM
    • Replies: 0
    • Views: 19,356
    mrdgaf
    01-24-2019, 05:20 AM Go to last post

  20. [SLEEPER:] Conditional count help

    Started by jmenche, 12-04-2014 08:54 AM
    • Replies: 1
    • Views: 18,148
    Bob Phillips
    01-03-2015, 06:14 AM Go to last post
Page 1 of 4 1 2 3 ... LastLast

Forum Information and Options

Users Browsing this Forum

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