Search:

Tag: sumproduct function

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] COUNTIFS and SUMIFS with a condition to exclude rows whose value is in another range

    Started by MatrixMan‎, 08-14-2023 06:22 PM
    countifs formula, sumifs formula, sumproduct function 1 Attachment(s)
    • 323
    Last Post: 08-17-2023 09:49 AM
    by Sam Capricci  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] INDIREKT() and SUMPRODUCT() not working

    Started by Tresfjording‎, 03-27-2023 09:45 AM
    indirect, indirect formula, sumproduct function
    • 277
    Last Post: 03-28-2023 02:42 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] SUMPRODUCT arrays different size

    Started by guillaume0314‎, 09-15-2022 01:27 PM
    array, sumproduct function 4 Attachment(s)
    • 721
    Last Post: 09-30-2022 01:30 PM
    by guillaume0314  Go to last post

    Forum:
    Excel Formulas & Functions

  4. SUMPRODUCT Numbers only in a filtered range

    Started by Duncan McKee‎, 02-05-2021 10:39 AM
    ignore text, sumproduct for filtering, sumproduct function 4 Attachment(s)
    • 513
    Last Post: 02-09-2021 09:50 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Make a sumproduct dynamic

    Started by Tonx‎, 01-24-2021 02:07 PM
    dynamic, dynamic range sum, sumproduct function
    • 442
    Last Post: 01-24-2021 02:51 PM
    by Limor_OP  Go to last post

    Forum:
    Excel Formulas & Functions

  6. SUMPRODUCT with LEN to sum values in rows matching a specific word

    Started by Keyb0‎, 09-15-2020 07:50 PM
    len function, substitute function, sumproduct function 1 Attachment(s)
    • 547
    Last Post: 09-17-2020 01:18 PM
    by canapone  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Sum Product is showing 0 when i use f9 to evaluate, it shows 1.

    Started by jeeke‎, 09-26-2019 05:29 PM
    sumproduct, sumproduct calculation, sumproduct function 3 Attachment(s)
    • 567
    Last Post: 09-27-2019 01:07 PM
    by Moo the Dog  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] SUMPRODUCT/IF/COUNTIFS formula returning a #DIV/0 error

    Started by Nate_from_Australia‎, 11-28-2018 01:35 AM
    #div/0, countifs 2010, help challenging problem, sumproduct date range, sumproduct function 1 Attachment(s)
    • 1,400
    Last Post: 11-28-2018 02:04 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] sumproduct - sum the same abbreviated titles of medical journals

    Started by Oncology‎, 10-25-2018 08:43 AM
    sumproduct function 3 Attachment(s)
    • 594
    Last Post: 10-26-2018 05:50 AM
    by Oncology  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] evaluate sumproduct

    Started by kcaisaacs‎, 08-30-2017 08:49 AM
    evaluate, sumproduct function
    • 507
    Last Post: 08-30-2017 09:16 AM
    by xlnitwit  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  11. [SOLVED] Sumifs or Array to calculate Total Cost Per Week

    Started by dannajones‎, 07-11-2017 12:42 PM
    array formula, sumproduct function 2 Attachment(s)
    • 632
    Last Post: 07-11-2017 03:44 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel General

  12. How to use subtotal in sumproduct with multiple criteria

    Started by Daniel Tou‎, 05-10-2017 04:53 PM
    subtotal, sumproduct function 1 Attachment(s)
    • 2,525
    Last Post: 05-11-2017 05:11 AM
    by Daniel Tou  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Sumproduct of multiple column (same row) that meet multiple criterias

    Started by dirdjo‎, 10-28-2016 03:15 AM
    multiple column, sumproduct function 4 Attachment(s)
    • 1,011
    Last Post: 10-28-2016 03:57 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Sum time across multiple time intervals that overlaps with a reference interval

    Started by Marbleking‎, 10-22-2016 07:28 PM
    array formula, proportionally, sumproduct function, time overlap 5 Attachment(s)
    • 1,901
    Last Post: 10-24-2016 08:12 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  15. How to count unique text & number to have same function with distinct count in office 2013

    Started by FM_mine‎, 04-06-2016 06:46 AM
    count formula, distinct count, sumproduct function 2 Attachment(s)
    • 2,117
    Last Post: 04-11-2016 11:14 PM
    by FM_mine  Go to last post

    Forum:
    Excel Formulas & Functions

  16. COUNTIFS versus SUMPRODUCT

    Started by JPSIMMON‎, 09-17-2015 01:14 AM
    count by month, countif and sumif, countifs, sumproduct function
    • 681
    Last Post: 09-17-2015 11:27 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Sumproduct tiered rates

    Started by nickmangan‎, 09-01-2015 06:23 AM
    sumproduct function, tiered pricing 3 Attachment(s)
    • 3,634
    Last Post: 09-01-2015 07:02 AM
    by cbatrody  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] OR conditions in a SUMPRODUCT formula

    Started by razz0807‎, 08-26-2015 11:50 AM
    sumproduct function
    • 579
    Last Post: 08-27-2015 09:25 AM
    by daddylonglegs  Go to last post

    Forum:
    Excel Formulas & Functions

  19. SUMPRODUCT for multiple sheets and columns

    Started by xavier_‎, 08-13-2015 04:49 AM
    indirect function, multiple sheets, sumproduct, sumproduct across sheets, sumproduct function 1 Attachment(s)
    • 1,983
    Last Post: 08-13-2015 07:24 AM
    by Masa1989  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Sumproduct help

    Started by LIZZIELEMAN‎, 03-06-2015 11:38 AM
    sumproduct date range, sumproduct function, sumproduct help, sumproduct value
    • 741
    Last Post: 03-06-2015 12:02 PM
    by Speshul  Go to last post

    Forum:
    Excel General

  21. Sumproduct help

    Started by LIZZIELEMAN‎, 02-20-2015 10:05 AM
    sumproduct across sheets, sumproduct date range, sumproduct formula modify, sumproduct function
    • 603
    Last Post: 02-20-2015 10:25 AM
    by ChemistB  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Making a Complicated Sumproduct into a Function

    Started by HCLax‎, 07-09-2014 08:53 AM
    challenge, formula to vba, sumproduct function
    • 545
    Last Post: 07-09-2014 09:41 AM
    by Kaper  Go to last post

    Forum:
    Excel Programming / VBA / Macros

Results 1 to 22 of 22

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1