Consulting

  1. Announcement:
    Happy birthday VBAX for May
    Aussiebear (Moderator)
    04-06-2024
    Views:
    2,356
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,791
    Zack Barresse
    04-11-2009, 01:40 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
    1 Attachment(s)
    • Replies: 22
    • Views: 64,929
    Simon Lloyd
    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
    1 Attachment(s)
    • Replies: 7
    • Views: 34,551
    BobBarker
    02-25-2011, 12:27 PM Go to last post

  4. 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,630
    rajiv_h
    06-17-2020, 04:25 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,756
    Bob Phillips
    04-11-2009, 02:43 PM Go to last post

  1. [SOLVED:] #VALUE Error using Sumproduct

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

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

    Started by khameleon1, 02-23-2017 09:25 AM
    2 Attachment(s)
    • Replies: 7
    • Views: 23,297
    Aflatoon
    03-01-2017, 10:09 AM Go to last post

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

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

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

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

  5. [SOLVED:] A job for SP?

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

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

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

  7. Moved: Advice: Redefine type of variable

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

  8. Advice: Sorting and Filtering with Array Formulas

    Started by mikerickson, 04-26-2009 09:59 PM
    • Replies: 2
    • Views: 5,942
    arkusM
    11-04-2009, 09:36 AM Go to last post

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

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

  10. [SOLVED:] Average of Values in Column E for each value in Column B - help

    Started by Foxtrot, 04-25-2009 09:54 AM
    1 Attachment(s)
    • Replies: 4
    • Views: 5,277
    Aussiebear
    04-25-2009, 10:56 AM Go to last post

  11. [SOLVED:] Blockbusters Array

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

  12. [SOLVED:] Braindead on Sumproduct

    Started by Opv, 03-13-2010 08:11 PM
    1 Attachment(s)
    • Replies: 5
    • Views: 6,404
    Opv
    03-14-2010, 02:25 PM Go to last post

  13. [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

  14. [SOLVED:] Changing variables in SumProduct formula

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

  15. [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

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

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

  17. [SLEEPER:] Conditional count help

    Started by jmenche, 12-04-2014 08:54 AM
    • Replies: 1
    • Views: 18,093
    Bob Phillips
    01-03-2015, 06:14 AM Go to last post

  18. [SOLVED:] Create simplified function

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

  19. [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

  20. [SOLVED:] Help with sumproduct function

    Started by Digita, 05-11-2009 06:40 PM
    1 Attachment(s)
    • Replies: 3
    • Views: 4,926
    Digita
    05-12-2009, 05:20 PM Go to last post
Page 1 of 4 1 2 3 ... LastLast

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
  •  

Forum Rules