Search:

Tag: sumprodcut

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. How to transform Data from a weekly Schedule into daily shifts

    Started by ahmedsayedmu‎, 10-16-2023 08:46 AM
    array, countif, data arrangement, sumprodcut, visualisation
    • 199
    Last Post: 10-16-2023 10:39 AM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Combine SUMIFS INDEX MATCH and date range

    Started by TRF7‎, 07-12-2023 06:45 AM
    index and match, sumifs & dates, sumprodcut 2 Attachment(s)
    • 309
    Last Post: 07-12-2023 11:44 AM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Counting the number of people on leave per month

    Started by MAJID1479‎, 12-04-2022 03:53 AM
    sumprodcut 4 Attachment(s)
    • 571
    Last Post: 12-04-2022 06:52 PM
    by MAJID1479  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Dynamic Sumproduct !

    Started by 0Cool‎, 04-05-2022 01:26 AM
    sumprodcut
    • 251
    Last Post: 04-05-2022 02:09 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Counting matches with previous row

    Started by Excl3454‎, 02-17-2022 05:33 PM
    count, dublicates, sumprodcut 3 Attachment(s)
    • 1,022
    Last Post: 02-17-2022 06:33 PM
    by Excl3454  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Sumproduct using an array create on the go...

    Started by 0Cool‎, 09-01-2021 03:14 AM
    sumprodcut
    • 213
    Last Post: 09-01-2021 03:34 AM
    by 0Cool  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Exclude row from SUM and SUMPRODUCT formula

    Started by jaysenoz‎, 03-10-2021 01:56 PM
    sum, sumprodcut 1 Attachment(s)
    • 1,196
    Last Post: 03-10-2021 03:23 PM
    by Limor_OP  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] providing output if criteria matched.

    Started by sagarkarki69‎, 02-19-2021 09:03 AM
    countif, ifconditions, sumprodcut 2 Attachment(s)
    • 459
    Last Post: 02-21-2021 05:26 AM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] how to calculate sum between two months?

    Started by sagarkarki69‎, 09-22-2020 06:35 AM
    dates, months, sum, sumifs & dates, sumprodcut 1 Attachment(s)
    • 443
    Last Post: 09-22-2020 07:58 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  10. SUMPRODUCT with a dynamic array or any alternative might help

    Started by aria24‎, 04-04-2020 03:52 AM
    dynamic array, last active cell, sumprodcut 2 Attachment(s)
    • 828
    Last Post: 04-04-2020 06:52 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  11. COUNTIF when filter applied to table.

    Started by Zed.jpeg‎, 01-10-2020 03:22 PM
    column, countif, excel, filter, sumprodcut 1 Attachment(s)
    • 1,267
    Last Post: 01-11-2020 09:26 AM
    by Fluff13  Go to last post

    Forum:
    Excel General

  12. Need updated Sum when data is filtered

    Started by Zed.jpeg‎, 01-10-2020 03:00 PM
    column, countif, excel, filter, sumprodcut 1 Attachment(s)
    • 777
    Last Post: 01-11-2020 02:14 AM
    by AliGW  Go to last post

    Forum:
    Office 365

  13. [SOLVED] Trying to use a formula to rank with a condition

    Started by tonym33‎, 11-19-2019 04:49 PM
    rank if, sumprodcut, top 10 results 1 Attachment(s)
    • 577
    Last Post: 11-26-2019 11:02 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] sumproduct month and other cirteria

    Started by moneypennie21‎, 01-15-2019 04:41 AM
    criteria, multiple, sumprodcut
    • 441
    Last Post: 01-15-2019 06:14 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  15. SUMPRODUCT suggestion to speed up

    Started by melvinkoshy‎, 12-28-2018 06:05 AM
    sumif, sumprodcut 3 Attachment(s)
    • 1,039
    Last Post: 01-03-2019 03:48 AM
    by jason.b75  Go to last post

    Forum:
    Excel General

  16. [SOLVED] Summing up every 125 rows

    Started by Rakel‎, 10-30-2018 07:21 AM
    index, mod, offset, sum, sumprodcut 3 Attachment(s)
    • 655
    Last Post: 11-08-2018 03:32 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  17. SUMPRODUCT for all cells with VLOOKUP or IF or SUMIFS

    Started by krishkarthik‎, 07-27-2018 08:07 AM
    sumif and condition, sumprodcut, total in cell, vlook up 3 Attachment(s)
    • 972
    Last Post: 07-28-2018 04:22 PM
    by krishkarthik  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Countifs across tabs and every other column

    Started by dsmith8‎, 02-20-2018 04:53 AM
    column + 1, countifs, formula, sumprodcut 2 Attachment(s)
    • 519
    Last Post: 02-20-2018 11:56 AM
    by Special-K  Go to last post

    Forum:
    Excel Formulas & Functions

  19. combine several SUMPRODUCT formulas

    Started by esbencito‎, 02-15-2018 12:21 AM
    sumprodcut
    • 436
    Last Post: 02-15-2018 02:54 AM
    by shukla.ankur281190  Go to last post

    Forum:
    Excel General

  20. [SOLVED] Sumproduct gives Value error

    Started by tabkaz‎, 02-07-2018 08:58 AM
    indirect, sumif, sumprodcut, sumproduct #value! error 1 Attachment(s)
    • 3,206
    Last Post: 02-08-2018 01:48 AM
    by tabkaz  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] SumProduct or VLookup

    Started by Margate‎, 01-19-2018 01:55 PM
    index + match, sumprodcut 1 Attachment(s)
    • 467
    Last Post: 01-19-2018 02:15 PM
    by Margate  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] Formula conversion from date string to numbers

    Started by Margate‎, 01-13-2018 01:57 PM
    date, date and time, formula, sumif date, sumprodcut 1 Attachment(s)
    • 716
    Last Post: 01-14-2018 03:38 PM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Count "x" ONLY if corresponding item number unique in other column

    Started by esbencito‎, 01-08-2018 05:26 AM
    array formula, countif, frequency, sumprodcut 4 Attachment(s)
    • 1,086
    Last Post: 01-09-2018 05:48 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  24. Sumproduct, Max, Index, Match and Randbetween in one Formula

    Started by shpaul‎, 06-07-2017 02:07 PM
    index & match, max date, randbtween, sumprodcut 4 Attachment(s)
    • 1,026
    Last Post: 06-08-2017 04:11 PM
    by Syrkrasi  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Sum If Divisible by 100

    Started by sskgintl‎, 06-07-2017 12:02 AM
    divisible by, mod, sumprodcut
    • 1,481
    Last Post: 06-07-2017 12:03 AM
    by humdingaling  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Is it possible to use Countifs to count only unique values based on a defferent data range

    Started by OmarQA‎, 03-16-2017 10:00 AM
    countifs, distinct, sumprodcut, unique 4 Attachment(s)
    • 701
    Last Post: 03-19-2017 08:11 AM
    by OmarQA  Go to last post

    Forum:
    Excel Formulas & Functions

  27. SUMPRODUCT formula between worksheets

    Started by chrismeka‎, 09-16-2016 09:43 AM
    formula assistance, isnumber, sumprodcut
    • 653
    Last Post: 09-16-2016 08:59 PM
    by AlRicotta  Go to last post

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Countifs on multiple columns & criteria

    Started by tabkaz‎, 05-12-2016 09:18 AM
    count, count and if, count blank cells, sumif, sumprodcut 1 Attachment(s)
    • 1,107
    Last Post: 05-13-2016 02:59 AM
    by zbor  Go to last post

    Forum:
    Excel Formulas & Functions

  29. SUMPRODUCT Date Range

    Started by ExcelNotSoWizard‎, 05-05-2016 03:26 PM
    sumprodcut, sumproduct date compare, sumproduct date range
    • 771
    Last Post: 05-05-2016 11:53 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] Ignore Blank on array

    Started by mchambersusmc‎, 01-21-2016 05:46 PM
    error, formula, ignore blank, sumprodcut, value error 1 Attachment(s)
    • 891
    Last Post: 01-22-2016 11:09 AM
    by hemesh  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Product count and lookup formula

    Started by Alaskan_grunt‎, 12-07-2015 03:27 AM
    count and if, sumprodcut, vlookup 3 Attachment(s)
    • 779
    Last Post: 12-07-2015 01:01 PM
    by Alaskan_grunt  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] Sumproduct not working when referencing a column of formulas

    Started by sskgintl‎, 08-07-2015 05:26 PM
    formula, sumprodcut
    • 3,126
    Last Post: 08-07-2015 07:25 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] SUMPRODUCT - Letter by Date range by Cell Value

    Started by Matt1998‎, 07-21-2015 11:04 AM
    sumprodcut 2 Attachment(s)
    • 536
    Last Post: 07-21-2015 11:13 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  34. SUMIF criteria is a code

    Started by JPSIMMON‎, 06-05-2015 11:54 AM
    criteria column, sumif, sumprodcut
    • 807
    Last Post: 06-05-2015 01:05 PM
    by Craig K.  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Subtotals with HIDDEN rows AND columns given some criteria

    Started by jalo638‎, 08-08-2014 01:01 PM
    countif, hidden column, offset, subtotal, sumprodcut 3 Attachment(s)
    • 2,566
    Last Post: 08-08-2014 08:05 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 43
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1