Search:

Tag: sumproduct

Page 3 of 23 1 2 3 4 5 6

Search: Replies Views Search took 0.01 seconds; generated 18 minute(s) ago.

  1. Find the sum of multiple criteria, multiplied by a percentage with a max

    Started by Ivyie‎, 08-09-2021 05:00 PM
    max, sum, sumifs, sumproduct 1 Attachment(s)
    • 431
    Last Post: 08-10-2021 12:33 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Sumproduct with multiple criteria and partial text match help

    Started by Britt24‎, 07-10-2021 11:35 PM
    help a dummy, multiple criteria, partial text match, sumproduct 1 Attachment(s)
    • 4,066
    Last Post: 07-12-2021 12:25 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Dynamic sum across various sheets - sumifs / sumproduct / indirect

    Started by sktcrvr‎, 07-01-2021 05:08 AM
    indirect, sumifs, sumproduct 2 Attachment(s)
    • 662
    Last Post: 07-02-2021 03:06 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel - New Users/Basics

  4. [SOLVED] Sum product as count if's with dates and gaps in data

    Started by moneypennie21‎, 06-28-2021 10:02 AM
    date, gaps, sumproduct 2 Attachment(s)
    • 740
    Last Post: 06-29-2021 03:35 AM
    by moneypennie21  Go to last post

    Forum:
    Excel Formulas & Functions

  5. How to copy cell value if other cell meets criteria

    Started by thomasuponor‎, 06-07-2021 06:19 AM
    condition, copy if, copy if function, sumproduct 2 Attachment(s)
    • 371
    Last Post: 06-07-2021 08:56 AM
    by queuesef  Go to last post

    Forum:
    Excel General

  6. [SOLVED] Right syntax for SUMPRODUCT and SUM functions combined.

    Started by Orif‎, 05-30-2021 10:46 PM
    sum, sumproduct 1 Attachment(s)
    • 640
    Last Post: 05-31-2021 06:00 AM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  7. SUMPRODUCT formula to calculate YTD numbers

    Started by juliegeorge792‎, 05-10-2021 04:38 PM
    calculating ytd, sumproduct, ytd 4 Attachment(s)
    • 2,321
    Last Post: 05-11-2021 03:47 PM
    by CARACALLA  Go to last post

    Forum:
    Excel General

  8. Using SUMPRODUCT (no SUMIFS) to summarize mapped data

    Started by LMB1991‎, 05-10-2021 07:23 AM
    sumifs, sumproduct 4 Attachment(s)
    • 520
    Last Post: 05-10-2021 08:58 AM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  9. SUMPRODUCT and FREQUENCY to return unique values based on criteria

    Started by thomasuponor‎, 03-26-2021 06:59 AM
    edate, frequency, sumproduct 2 Attachment(s)
    • 604
    Last Post: 03-26-2021 08:46 AM
    by thomasuponor  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Sumproduct with a dynamic moving range

    Started by sachindmnc‎, 03-11-2021 06:38 AM
    dynamic array, sumproduct 2 Attachment(s)
    • 750
    Last Post: 03-11-2021 12:07 PM
    by sachindmnc  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Rifle Club Scoring sheet - summing of numbers and letters

    Started by marc991‎, 02-19-2021 07:38 PM
    countif, isnumber, sumproduct 2 Attachment(s)
    • 982
    Last Post: 02-20-2021 04:49 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  12. [SOLVED] Sum three columns with one criteria

    Started by Shruder‎, 02-11-2021 04:13 PM
    sumproduct 1 Attachment(s)
    • 478
    Last Post: 04-17-2021 08:33 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  13. SUMPRODUCT Multiple Criteria with Distinct Values

    Started by KJ_‎, 02-10-2021 08:13 PM
    distinct values, multiple critera, sumproduct 2 Attachment(s)
    • 2,732
    Last Post: 02-11-2021 06:01 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  14. I need to count nonblank values in a filtered list by two criteria. Please help!

    Started by Jarvis_Cain‎, 01-25-2021 02:57 PM
    filtered range, multiple criteria, subtotal, subtotal if, sumproduct 1 Attachment(s)
    • 704
    Last Post: 01-31-2021 01:46 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] IF cells in a range are empty, reference values in another cell range

    Started by KJ_‎, 01-13-2021 02:28 AM
    empty cells, multiple criteria ranges, sumproduct 4 Attachment(s)
    • 596
    Last Post: 01-14-2021 12:55 AM
    by KJ_  Go to last post

    Forum:
    Excel Formulas & Functions

  16. Count difference between dates for this week values only

    Started by Omen‎, 01-03-2021 08:19 PM
    countif, excel, sumproduct 1 Attachment(s)
    • 1,088
    Last Post: 01-04-2021 07:25 AM
    by Omen  Go to last post

    Forum:
    Excel General

  17. Help with Excel formula - Countif - Greater Than ,Less Than , Equal to a Range of Dates

    Started by pepe85‎, 12-21-2020 05:38 PM
    countif, equal to, greater than, less than, sumproduct 1 Attachment(s)
    • 930
    Last Post: 12-21-2020 11:27 PM
    by Gregb11  Go to last post

    Forum:
    Excel General

  18. [SOLVED] Sum of cells by logic in a row

    Started by chintakk‎, 12-15-2020 06:25 PM
    sumproduct 1 Attachment(s)
    • 390
    Last Post: 12-16-2020 10:59 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] DAX - SUMPRODUCT Help

    Started by man0s66‎, 12-15-2020 06:29 AM
    dax, dax formula, sumproduct 4 Attachment(s)
    • 1,201
    Last Post: 12-16-2020 09:12 AM
    by man0s66  Go to last post

    Forum:
    Excel General

  20. [SOLVED] Count date cells for specific month

    Started by bauvache‎, 12-02-2020 07:53 AM
    data range, dates, formula, month, sumproduct
    • 678
    Last Post: 12-02-2020 09:48 AM
    by bauvache  Go to last post

    Forum:
    Excel General

  21. SUM data based on row with criteria

    Started by pblnrao‎, 11-27-2020 05:07 AM
    sumif, sumproduct
    • 332
    Last Post: 11-27-2020 05:19 AM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Sumproduct logic array issue

    Started by 3foo3‎, 11-19-2020 04:02 PM
    array, excel, logic, sumif, sumproduct 3 Attachment(s)
    • 778
    Last Post: 11-19-2020 06:10 PM
    by 3foo3  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Counting non-empty merged cells on another closed document with SUMPRODUCT

    Started by baxius‎, 11-10-2020 04:58 AM
    cells, count, merged cells, sumproduct 1 Attachment(s)
    • 473
    Last Post: 11-10-2020 05:28 AM
    by baxius  Go to last post

    Forum:
    Excel Formulas & Functions

  24. How do I exclude certain cells from a sum product formula in Excel?

    Started by ardask‎, 10-30-2020 07:28 AM
    excel, formula, sumproduct 2 Attachment(s)
    • 1,298
    Last Post: 10-30-2020 11:04 AM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  25. How do I exclude certain cells from a sum product formula in Excel?

    Started by ardask‎, 10-30-2020 07:15 AM
    excel, formula, sumproduct 1 Attachment(s)
    • 534
    Last Post: 10-30-2020 12:53 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Calculating a blended rate

    Started by haskenazi‎, 10-29-2020 08:30 PM
    formula, function, sliding scale, sumproduct 2 Attachment(s)
    • 2,713
    Last Post: 10-29-2020 09:10 PM
    by Phuocam  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Weighted average filtering a table with a text pattern

    Started by ssierralta‎, 10-29-2020 12:13 PM
    sumproduct 2 Attachment(s)
    • 332
    Last Post: 10-29-2020 02:09 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Use SUMPRODUCT, LEFT, and YEAR functions together

    Started by excelmagic20‎, 10-22-2020 07:49 AM
    left, month, right(), sumproduct, year 1 Attachment(s)
    • 447
    Last Post: 10-22-2020 09:27 AM
    by p45cal  Go to last post

    Forum:
    Excel General

  29. Sum Distinct Values within Time Constraints?

    Started by tryhard‎, 10-21-2020 12:54 PM
    array, distinct values, duplicate controls, sumif, sumproduct 4 Attachment(s)
    • 578
    Last Post: 10-22-2020 12:01 PM
    by tryhard  Go to last post

    Forum:
    Excel General

  30. Sum numbers in a column if values in another column contain the number in another cell

    Started by captmegadeath‎, 10-16-2020 10:08 PM
    partial, sum, sumif, sumifs, sumproduct 2 Attachment(s)
    • 575
    Last Post: 10-17-2020 02:23 PM
    by alansidman  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Need to sum all rows in a SUMPRODUCT nested array when condition cell is blank

    Started by regnile‎, 09-11-2020 07:17 PM
    array, conditions, sumproduct 1 Attachment(s)
    • 439
    Last Post: 09-16-2020 01:33 PM
    by regnile  Go to last post

    Forum:
    Excel Formulas & Functions

  32. SUMPRODUCT count specific text criteria containing month year in a range, possible?

    Started by Danz-‎, 09-01-2020 10:15 AM
    assistance, excel & formula, sumproduct 1 Attachment(s)
    • 519
    Last Post: 09-02-2020 05:57 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Sumif (or) where criteria = any value in a column

    Started by sharper1989‎, 08-25-2020 01:07 PM
    cell reference, multiple criteria, sumif, sumproduct
    • 485
    Last Post: 08-25-2020 01:29 PM
    by Limor_OP  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] how to count month from the date format "mm/dd/yyyy" without converting it ?

    Started by sagarkarki69‎, 08-02-2020 07:43 AM
    countif, date & text formula, month, sumproduct, text 1 Attachment(s)
    • 916
    Last Post: 08-02-2020 09:29 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Sumproduct if conditions are met

    Started by mrsak87‎, 07-21-2020 09:11 AM
    criteria, sumproduct 3 Attachment(s)
    • 555
    Last Post: 07-22-2020 04:52 AM
    by Haluk  Go to last post

    Forum:
    Excel Formulas & Functions

Results 71 to 105 of 791
Page 3 of 23 1 2 3 4 5 6

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1