Log in

View Full Version : SUMPRODUCT And Other Array Functions


  1. Mismatch for Sumproduct (4 replies)
  2. [SOLVED:] Sumproduct/Subtotal > issue (13 replies)
  3. [SOLVED:] Sumif not working (2 replies)
  4. Comparing two lists, identifying and highlighting missing entries using MATCH (0 replies)
  5. [SOLVED:] Adding two columns together with two criteria (3 replies)
  6. [SOLVED:] SUMIFS help please (2 replies)
  7. [SOLVED:] Using Countifs & Weekdays (7 replies)
  8. [SOLVED:] #VALUE! Error for Single Criterion Sumproduct Function (7 replies)
  9. [SOLVED:] #VALUE Error using Sumproduct (5 replies)
  10. [SOLVED:] Blockbusters Array (5 replies)
  11. Sleeper: Matrix multiplication in VBA (not the application. one) (6 replies)
  12. [SOLVED:] Search contents of multiline cells within entire workbook (8 replies)
  13. [SLEEPER:] Conditional count help (1 replies)
  14. Sleeper: Conditional cumulative sum (2 replies)
  15. [SOLVED:] Changing variables in SumProduct formula (9 replies)
  16. [SOLVED:] SUMPRODUCT returning FALSE (9 replies)
  17. [SOLVED:] VBA issue: Sumproduct & index and match - multiple criteria (3 replies)
  18. [SOLVED:] Sumproduct instead of countif. 1 digit numbers problem. (8 replies)
  19. [SOLVED:] Sumproduct with Variables (1 replies)
  20. [SOLVED:] Values From A Closed Workbook (5 replies)
  21. [SOLVED:] Ok, what am i doing wrong in this one? (10 replies)
  22. [SOLVED:] Comparing a range against a range (6 replies)
  23. [SOLVED:] And vs Or and Not Conditions (7 replies)
  24. [SOLVED:] .FormulaArray entry limited to 256 character equation?? (1 replies)
  25. Sleeper: ReDim a type (1 replies)
  26. [SOLVED:] Get Unique days per MD per patient (9 replies)
  27. Sleeper: Thank you so much - eom (0 replies)
  28. [SOLVED:] A job for SP? (8 replies)
  29. [SOLVED:] SumProduct vs GetPivotData (2 replies)
  30. Sleeper: Matrix structures problem (4 replies)
  31. Sleeper: Is .FormulaArray limited to Range? (2 replies)
  32. [SOLVED:] Calculate Revenue Based on Date Periods (5 replies)
  33. [SOLVED:] Sumproduct result displays incorrectly on sheet (4 replies)
  34. Sleeper: sum of*a list of*numbers*recorded*in a single*cell (0 replies)
  35. [SOLVED:] Create simplified function (5 replies)
  36. [SOLVED:] Sum divide (7 replies)
  37. [SOLVED:] Sumproduct using LEFT text from another worksheet? (23 replies)
  38. [SOLVED:] Braindead on Sumproduct (5 replies)
  39. [SOLVED:] Sumproduct/Array formula for cells with date (4 replies)
  40. Sleeper: Calculating Percentages (1 replies)
  41. [SOLVED:] Lookup problem (6 replies)
  42. [SOLVED:] "Calculating Cells" taking way too long due to SumProduct (8 replies)
  43. Sleeper: General SUMPRODUCT/ARRAY Questions (6 replies)
  44. [SOLVED:] Is this a job for SUMPRODUCT? Or is it easier? (25 replies)
  45. [SOLVED:] Sumproduct forumla needed for complex sum. (4 replies)
  46. [SOLVED:] Sumproduct short question - count in sumproduct (5 replies)
  47. Sleeper: 2 Sumproduct Function same result (5 replies)
  48. Sleeper: Sumproduct Lessons (7 replies)
  49. SUMPRODUCT Step By Step - Part 3 (14 replies)
  50. [SOLVED:] Help with sumproduct function (3 replies)
  51. Advice: Sorting and Filtering with Array Formulas (2 replies)
  52. [SOLVED:] Average of Values in Column E for each value in Column B - help (4 replies)
  53. [SOLVED:] Product if... (4 replies)
  54. [SOLVED:] SUMPRODUCT (or array formula?) question (16 replies)
  55. SUMPRODUCT Step By Step - Part 2 (7 replies)
  56. SUMPRODUCT Step By Step - Part 1 (22 replies)
  57. This Forum (0 replies)
  58. SUMPRODUCT forum (0 replies)
  59. [SOLVED:] How to use SUMPRODUCT for text offset over a discontiguous range? [Tutorial] (8 replies)
  60. [SOLVED:] SUMPRODUCT help (3 replies)
  61. [SOLVED:] Sumproduct in VBA (4 replies)
  62. [SOLVED:] More help with SumProduct (6 replies)
  63. [SOLVED:] SUMPRODUCT in VBA Code (2 replies)