Search:

Tag: sumproduct

Page 1 of 24 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. [SOLVED] Count with criteria in different ranges

    Started by 77highland‎, 03-25-2025 08:34 AM
    aggregate, count, sumproduct 4 Attachment(s)
    • 183
    Last Post: 03-25-2025 10:54 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Index Match Match with multiple criteria

    Started by 77highland‎, 02-27-2025 10:26 AM
    index, match, sumproduct 1 Attachment(s)
    • 206
    Last Post: 02-27-2025 04:42 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Slow calculation/sheet performance when using multiple SUMPRODUCT

    Started by 77highland‎, 01-31-2025 01:37 PM
    calculation, performance, recalculation, slow, sumproduct 3 Attachment(s)
    • 372
    Last Post: 02-01-2025 12:50 PM
    by djclements  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Count of numbers of times a column had lowest value in each row of a range

    Started by MarkCo‎, 01-31-2025 12:32 AM
    min or countsifs and min, sumproduct
    • 107
    Last Post: 01-31-2025 01:31 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] COUNTIFS with multiple criteria across non-contiguous ranges

    Started by 77highland‎, 01-23-2025 08:01 PM
    countifs, multiple criteria, non-contiguous ranges, sumproduct
    • 241
    Last Post: 01-27-2025 08:14 AM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] SUMPRODUCT - ISNUMBER - SEARCH - WITH IFS and Does Not Equal

    Started by Btray90‎, 12-01-2024 11:07 PM
    does not equal to, ifs, isnumber+search function, sumproduct 2 Attachment(s)
    • 465
    Last Post: 12-03-2024 02:28 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Sumproduct formula returns 0 or does not recognise the conditions, sumif aswell

    Started by pmma‎, 11-11-2024 07:32 AM
    sumif, sumproduct 1 Attachment(s)
    • 335
    Last Post: 11-11-2024 10:38 AM
    by josephteh  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Count differences between ranges (with multiple rows & columns) with multiple criteria

    Started by 77highland‎, 10-24-2024 04:44 AM
    countif, sum, sumproduct 3 Attachment(s)
    • 178
    Last Post: 10-24-2024 05:29 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] SUMPRODUCT, problem with four of them.

    Started by B.W.B.‎, 08-17-2024 11:03 AM
    sumproduct, sumproduct array 5 Attachment(s)
    • 227
    Last Post: 08-17-2024 12:08 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Count number of entries with duplicates once in a filtered worksheet.

    Started by avijit74‎, 08-13-2024 03:06 AM
    duplicate once, offset, subtotal, sumproduct 6 Attachment(s)
    • 496
    Last Post: 08-18-2024 05:39 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Average range with multiple columns and rows with multiple criteria

    Started by 77highland‎, 08-01-2024 04:30 AM
    average, index, match, sumproduct 2 Attachment(s)
    • 207
    Last Post: 08-02-2024 02:36 AM
    by Czeslaw  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Sumproduct 2 AND condition every nth COLUMN, counting blank and not blank

    Started by Jeremy Longs‎, 07-26-2024 05:28 AM
    array, count, sumproduct 3 Attachment(s)
    • 290
    Last Post: 07-26-2024 10:57 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Avg. from division across TWO 2D ranges inc. with 1D criteria AND ignoring error values!

    Started by schnide‎, 07-25-2024 03:17 PM
    array, sumproduct 1 Attachment(s)
    • 204
    Last Post: 07-25-2024 04:00 PM
    by schnide  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Average with SUMPRODUCT across 2D range inc. with 1D criteria AND ignoring error values!

    Started by schnide‎, 07-24-2024 04:01 AM
    sumproduct 2 Attachment(s)
    • 298
    Last Post: 07-24-2024 06:15 AM
    by schnide  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] SUMPRODUCT - Two Columns of Criteria, Not Exact Match

    Started by Btray90‎, 06-30-2024 10:36 PM
    multiple criteria columns, not exact match, sumproduct 2 Attachment(s)
    • 563
    Last Post: 07-22-2024 10:34 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  16. [SOLVED] SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

    Started by 77highland‎, 06-12-2024 10:17 PM
    sumifs, sumproduct 1 Attachment(s)
    • 284
    Last Post: 06-13-2024 07:46 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] SumProduct & Index Match

    Started by aurelien_21‎, 06-04-2024 09:01 AM
    index, match, sumif, sumproduct 2 Attachment(s)
    • 276
    Last Post: 06-05-2024 06:57 AM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  18. SumProduct for external files using cell references for file path?

    Started by jbaich‎, 05-23-2024 06:44 PM
    sumproduct, sumproduct #value! error, sumproduct external file, sumproduct named ranges 1 Attachment(s)
    • 400
    Last Post: 05-24-2024 09:04 AM
    by jbaich  Go to last post

    Forum:
    Excel Formulas & Functions

  19. COUNTIF function which counts visible rows only after filtering (Sumproduct)?

    Started by JoskoJurjevic‎, 05-03-2024 03:54 AM
    countif, sumproduct 3 Attachment(s)
    • 320
    Last Post: 05-03-2024 06:12 AM
    by JoskoJurjevic  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Count cells containing keywords with multiple criteria

    Started by Kailef‎, 04-13-2024 10:36 PM
    countifs, formula, search, sumproduct 3 Attachment(s)
    • 283
    Last Post: 04-14-2024 02:31 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] How can I enhance this SUMPRODUCT formula to only counts cells greater than zero?

    Started by schnide‎, 03-27-2024 05:36 AM
    sumproduct 4 Attachment(s)
    • 347
    Last Post: 03-27-2024 01:01 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Sumif + Date Range + Lookup Value Problem

    Started by Harro6060‎, 03-25-2024 04:35 AM
    date range, lookup, sumproduct 3 Attachment(s)
    • 310
    Last Post: 03-25-2024 10:09 PM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Distinct count with 3 conditions (building and 2 dates)

    Started by Anais_2024‎, 03-20-2024 05:07 PM
    distinct count, sumproduct 2 Attachment(s)
    • 223
    Last Post: 03-20-2024 06:15 PM
    by DJunqueira  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] SUMPRODUCT: Property tax calculations

    Started by jamesy5‎, 03-11-2024 02:14 PM
    property tax, sumproduct 4 Attachment(s)
    • 313
    Last Post: 03-15-2024 08:49 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  25. [SOLVED] For me this is a conundrum, same formula two data sources, and one not working

    Started by Tresfjording‎, 03-08-2024 05:15 PM
    sumproduct 2 Attachment(s)
    • 264
    Last Post: 03-09-2024 06:04 PM
    by Tresfjording  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Weekly data into monthly data inc. splitting weeks that overlap months

    Started by dc007c0231‎, 02-29-2024 08:21 AM
    sumproduct 1 Attachment(s)
    • 742
    Last Post: 02-29-2024 08:41 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Taking weekly data and converting to monthly

    Started by dc007c0231‎, 02-28-2024 12:17 PM
    formula, sumproduct 3 Attachment(s)
    • 946
    Last Post: 03-04-2024 05:04 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] SUMPRODUCT bc of many conditions?

    Started by B.W.B.‎, 02-16-2024 09:17 AM
    match, sumif, sumifs, sumproduct 2 Attachment(s)
    • 322
    Last Post: 02-16-2024 12:42 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Sumproduct formula giving error

    Started by partlysunny‎, 01-17-2024 04:24 AM
    sumproduct 2 Attachment(s)
    • 259
    Last Post: 01-17-2024 01:48 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Need a workaround because SUMPRODUCT doesn't support wildcards

    Started by Royzer‎, 01-15-2024 01:37 PM
    sumproduct, wildcard 3 Attachment(s)
    • 354
    Last Post: 01-17-2024 02:50 PM
    by Royzer  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Combine Multiple Arrays/Matrices (Get the SUM) into a one big Array (Matrix)

    Started by alte.ianp‎, 01-13-2024 12:14 PM
    index, match, sumif + match, sumproduct 3 Attachment(s)
    • 874
    Last Post: 01-15-2024 07:28 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Dynamic Hourly Employee Headcount (including overnight staff)

    Started by excelhelp99‎, 01-11-2024 08:38 PM
    excel formula, sumproduct 3 Attachment(s)
    • 416
    Last Post: 01-13-2024 09:25 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] Sumproduct with Dynamic Ranges

    Started by WaylettChris‎, 12-22-2023 05:19 AM
    dynamic array, reference cells, sumproduct 1 Attachment(s)
    • 312
    Last Post: 12-22-2023 06:54 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] Sum data based on specific criteria

    Started by philip.michael.smith‎, 11-29-2023 11:20 PM
    criteria, sum, sumif, sumproduct 2 Attachment(s)
    • 399
    Last Post: 12-01-2023 03:35 AM
    by HansDouwe  Go to last post

    Forum:
    Excel General

  35. [SOLVED] SUMPRODUCT Issue with sheet names being variable

    Started by ptvland‎, 11-28-2023 02:08 AM
    excel, formula, sheet, sumproduct
    • 325
    Last Post: 11-28-2023 07:56 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 810
Page 1 of 24 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1