Search:

Tag: sumproduct

Page 1 of 23 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. Count cells containing keywords with multiple criteria

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

    Forum:
    Excel Formulas & Functions

  2. [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)
    • 152
    Last Post: 03-27-2024 01:01 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  4. [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)
    • 100
    Last Post: 03-20-2024 06:15 PM
    by DJunqueira  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] SUMPRODUCT: Property tax calculations

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

    Forum:
    Excel General

  6. [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)
    • 138
    Last Post: 03-09-2024 06:04 PM
    by Tresfjording  Go to last post

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] SUMPRODUCT bc of many conditions?

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

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Sumproduct formula giving error

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel Formulas & Functions

  12. 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)
    • 216
    Last Post: 01-15-2024 07:28 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Dynamic Hourly Employee Headcount (including overnight staff)

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

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Sumproduct with Dynamic Ranges

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

    Forum:
    Excel Formulas & Functions

  15. [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)
    • 210
    Last Post: 12-01-2023 03:35 AM
    by HansDouwe  Go to last post

    Forum:
    Excel General

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

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

    Forum:
    Excel Formulas & Functions

  17. Sumproduct with multiple criteria and table

    Started by shichiriz‎, 10-12-2023 10:22 AM
    sumproduct 2 Attachment(s)
    • 178
    Last Post: 10-12-2023 10:37 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] SUMPRODUCT with BYROW? MAP? INDEX?

    Started by paulma1960‎, 10-09-2023 08:12 AM
    byrow & lambda, dynamic array formula, map, sumproduct 2 Attachment(s)
    • 449
    Last Post: 10-09-2023 12:09 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column [PART2]

    Started by artiststevens‎, 10-09-2023 05:31 AM
    countif, index, match, sumproduct 1 Attachment(s)
    • 190
    Last Post: 10-09-2023 05:40 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Sum or Sumproduct or ? with dates in the table headers

    Started by blak9‎, 10-03-2023 08:44 AM
    sum, sumproduct 3 Attachment(s)
    • 269
    Last Post: 10-04-2023 07:37 AM
    by blak9  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] Help with Formula for COUNTIIFS INDEX MATCH Multiple Criteria Same Column

    Started by artiststevens‎, 09-18-2023 05:05 PM
    countif, index, match, sumproduct 11 Attachment(s)
    • 584
    Last Post: 10-17-2023 12:15 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Sum # of times a person does a task with a date filter (no pivot table)

    Started by JaimeS1‎, 09-08-2023 05:18 PM
    date filter, sum, sumproduct 2 Attachment(s)
    • 273
    Last Post: 09-12-2023 10:28 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Using SumProduct to return values based on criteria when date filter changes

    Started by JaimeS1‎, 09-01-2023 04:57 PM
    date slicer, formula, sumproduct 4 Attachment(s)
    • 385
    Last Post: 09-12-2023 02:45 PM
    by JaimeS1  Go to last post

    Forum:
    Excel Formulas & Functions

  24. sumproduct formula to find avg from multiple column

    Started by rishikrsaw‎, 08-23-2023 12:56 PM
    sumproduct 4 Attachment(s)
    • 293
    Last Post: 08-25-2023 02:58 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Include an OR inside the sumproduct function

    Started by Excl3454‎, 07-20-2023 07:08 PM
    formuala, if(or, isnumber, joining, sumproduct
    • 254
    Last Post: 07-20-2023 10:27 PM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Find average value and rank based on multiple criteria within same columns

    Started by hkucumb11‎, 06-27-2023 07:13 PM
    averageifs, rank, sumproduct 1 Attachment(s)
    • 204
    Last Post: 06-27-2023 08:36 PM
    by hkucumb11  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Mutile criterai accross multiple ranges to return a sum of matching values

    Started by 77highland‎, 06-15-2023 07:43 AM
    index, match, sumproduct 2 Attachment(s)
    • 274
    Last Post: 06-15-2023 09:37 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns

    Started by 77highland‎, 06-09-2023 04:48 PM
    count, countif, countifs, sumproduct 1 Attachment(s)
    • 261
    Last Post: 06-09-2023 05:19 PM
    by 77highland  Go to last post

    Forum:
    Excel Formulas & Functions

  29. SUMPRODUCT formula does not work when first opening Excel file

    Started by 23andme‎, 05-18-2023 06:18 PM
    helper column, lists, sumproduct, sumproduct #value! error 1 Attachment(s)
    • 278
    Last Post: 05-18-2023 08:06 PM
    by 23andme  Go to last post

    Forum:
    Excel Formulas & Functions

  30. Sumproduct vba code

    Started by robyrubyjane‎, 03-30-2023 04:10 AM
    logic, sumproduct, vba
    • 326
    Last Post: 03-30-2023 07:25 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  31. SUMIF Formula with exact text match, ignoring numbers

    Started by catsamjewelry‎, 01-28-2023 04:01 PM
    exact match, inventory, sumif, sumproduct 4 Attachment(s)
    • 358
    Last Post: 01-31-2023 05:22 PM
    by catsamjewelry  Go to last post

    Forum:
    Excel General

  32. Index Matching with SUMPRODUCT help

    Started by Danlogo10‎, 01-25-2023 04:55 PM
    index + match, sumproduct 1 Attachment(s)
    • 233
    Last Post: 01-25-2023 07:03 PM
    by tanasedn  Go to last post

    Forum:
    Excel General

  33. [SOLVED] sumproduct with date criteria and blanks in array

    Started by moneypennie21‎, 01-03-2023 09:27 AM
    blank cell, date, sumproduct 3 Attachment(s)
    • 431
    Last Post: 01-03-2023 10:49 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Sum with more than one column criteria

    Started by lthomashlb‎, 12-20-2022 03:07 PM
    left, sumif, sumproduct 2 Attachment(s)
    • 312
    Last Post: 12-20-2022 04:17 PM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Iterate Through an Array of Values to Determine SUMPRODUCT?

    Started by takoyaki‎, 11-15-2022 01:21 PM
    array formula, sumproduct
    • 390
    Last Post: 11-15-2022 03:12 PM
    by takoyaki  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 791
Page 1 of 23 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1