Search:

Tag: sumproduct

Page 7 of 23 FirstFirst 4 5 6 7 8 9 10

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

  1. [SOLVED] Sumifs based on filtered data

    Started by amartin575‎, 05-16-2018 01:58 PM
    filtered data, subtotal, sumifs, sumproduct, visible data 1 Attachment(s)
    • 849
    Last Post: 05-16-2018 08:04 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Manual Sheet to monitor Arrival and Departure patterns for categories

    Started by Zhang018‎, 05-05-2018 03:05 AM
    count, counti, excel, patterns, sumproduct 6 Attachment(s)
    • 3,302
    Last Post: 05-18-2018 06:15 AM
    by JohnTopley  Go to last post

    Forum:
    Excel General

  3. [SOLVED] Count Unique Values Based On Two Criteria - how do I update this formula?

    Started by JuNova‎, 04-29-2018 08:51 PM
    count unique values, multiple criteria, sumproduct 1 Attachment(s)
    • 470
    Last Post: 04-30-2018 03:27 AM
    by JuNova  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Finding value against specific cell against 2 conditions

    Started by rishiambekar‎, 04-20-2018 03:30 AM
    if statement, latest entry, sumproduct, weighted average 1 Attachment(s)
    • 603
    Last Post: 04-20-2018 05:47 AM
    by rishiambekar  Go to last post

    Forum:
    Excel General

  5. [SOLVED] Relative reference with Indirect function

    Started by sabiza‎, 04-17-2018 11:51 AM
    indirect, relative cell reference, sumif, sumproduct
    • 5,090
    Last Post: 04-17-2018 12:07 PM
    by sabiza  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] IFERROR not working

    Started by CBrechin‎, 04-05-2018 08:09 PM
    index, match, sumproduct 3 Attachment(s)
    • 2,231
    Last Post: 04-09-2018 03:13 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Working out the number of people on treatment on a day (and then for every day)

    Started by SGabe‎, 03-30-2018 07:23 PM
    countifs, counting, dates, sumproduct 5 Attachment(s)
    • 721
    Last Post: 03-31-2018 01:24 PM
    by Richard Buttrey  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Help with SUMPRODUCT in a large array

    Started by wizcreations‎, 03-30-2018 01:59 PM
    array, index, logic, small, sumproduct 1 Attachment(s)
    • 1,284
    Last Post: 03-30-2018 03:21 PM
    by wizcreations  Go to last post

    Forum:
    Excel Formulas & Functions

  9. calculate amount charged based on various rates

    Started by imran999‎, 03-13-2018 09:31 PM
    index/match, sumproduct, vlookup 1 Attachment(s)
    • 783
    Last Post: 03-14-2018 03:48 AM
    by imran999  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Count list not Match to a range as criteria and count duplicate as one and ignoring blank

    Started by brake‎, 03-03-2018 04:07 AM
    count, countif, match, sumproduct 2 Attachment(s)
    • 717
    Last Post: 03-03-2018 05:00 AM
    by brake  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] include ALL colour attributes in criteria range (SUMPRODUCT)

    Started by esbencito‎, 02-28-2018 02:33 AM
    array, criteria, sumproduct 2 Attachment(s)
    • 1,061
    Last Post: 02-28-2018 10:40 PM
    by esbencito  Go to last post

    Forum:
    Excel General

  12. [SOLVED] SUMPRODUCT with skipping columns and column Breaks

    Started by jhansrod‎, 02-24-2018 09:50 AM
    columns, sumproduct 2 Attachment(s)
    • 1,070
    Last Post: 02-24-2018 11:21 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Speeding up SUMPRODUCT/ SUMIFS array formula

    Started by esbencito‎, 02-23-2018 02:54 AM
    array, speed up array, sumifs, sumproduct 1 Attachment(s)
    • 4,841
    Last Post: 02-26-2018 02:14 AM
    by FDibbins  Go to last post

    Forum:
    Excel General

  14. [SOLVED] Slow time deleting filtered rows. Optimization help (sumproduct).

    Started by Pojzon‎, 02-17-2018 01:05 PM
    deleting a row, filter and freeze, optimization, sumproduct 2 Attachment(s)
    • 1,574
    Last Post: 02-20-2018 07:41 AM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] SUMPRODUCT where data and criteria ranges have blank values

    Started by Manwithaplan‎, 02-15-2018 09:40 PM
    blank cells, sumproduct 1 Attachment(s)
    • 885
    Last Post: 02-16-2018 04:06 AM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  16. weighted average with multiple weighted factors using SUMPRODUCT

    Started by esbencito‎, 02-15-2018 03:04 AM
    sumproduct, weighted average 1 Attachment(s)
    • 1,175
    Last Post: 02-15-2018 03:04 AM
    by esbencito  Go to last post

    Forum:
    Excel General

  17. [SOLVED] sumproduct with multiple arrays

    Started by wizadele14‎, 02-09-2018 08:46 AM
    arrays, sumproduct
    • 489
    Last Post: 02-09-2018 09:31 AM
    by wizadele14  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] SUMPRODUCT using INDEX and MATCH

    Started by moneypennie21‎, 02-02-2018 05:42 AM
    index, match, sumproduct 2 Attachment(s)
    • 809
    Last Post: 02-02-2018 09:33 AM
    by moneypennie21  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Help with COUNTIFS and/or SUMPRODUCT

    Started by bayouwxman‎, 01-31-2018 11:31 AM
    countifs, formula, sumproduct 4 Attachment(s)
    • 935
    Last Post: 01-31-2018 02:15 PM
    by bayouwxman  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] SUMPRODUCT with several criteria

    Started by esbencito‎, 01-26-2018 01:31 AM
    countif, criteria, isnumber, search, sumproduct
    • 1,013
    Last Post: 01-29-2018 10:11 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  21. Sumproduct - Date criteria to exclude total columns

    Started by no_mouse‎, 01-22-2018 01:44 PM
    sumproduct, sumproduct calculation, sumproduct date range, sumproduct formula modify
    • 838
    Last Post: 01-22-2018 02:53 PM
    by daddylonglegs  Go to last post

    Forum:
    Excel General

  22. Is it possible to sum the value in the column from only the first five cells with content

    Started by Kjerti05‎, 01-22-2018 11:03 AM
    countif, sumproduct 1 Attachment(s)
    • 348
    Last Post: 01-22-2018 11:29 AM
    by davsth  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Using SUMPRODUCT/ARRAY formula instead of helper column

    Started by esbencito‎, 01-22-2018 05:30 AM
    array formula, sum(index, sumif, sumproduct 4 Attachment(s)
    • 1,315
    Last Post: 01-23-2018 10:22 PM
    by esbencito  Go to last post

    Forum:
    Excel General

  24. [SOLVED] Sumproduct based on employee number and column titles

    Started by jantonio‎, 01-21-2018 02:23 PM
    sumproduct 1 Attachment(s)
    • 478
    Last Post: 01-21-2018 04:10 PM
    by jantonio  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Sumproduct in combination with other functions but excluding blank cells in range

    Started by divr‎, 01-11-2018 05:40 AM
    empty cells, left function, sumproduct 1 Attachment(s)
    • 1,087
    Last Post: 01-11-2018 06:15 AM
    by shukla.ankur281190  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Count One Criteria Across Multiple Worksheets with SUMPRODUCT(COUNTIF(INDIRECT shows error

    Started by Tryin2Excel‎, 12-22-2017 03:18 PM
    sumproduct, sumproduct across sheets
    • 1,203
    Last Post: 12-22-2017 05:13 PM
    by Tryin2Excel  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Sumproduct omitting zeros

    Started by thenormanizer‎, 12-13-2017 11:48 PM
    sumproduct
    • 582
    Last Post: 12-14-2017 02:35 AM
    by leelnich  Go to last post

    Forum:
    Excel General

  28. counting the number of occurrances of several numbers (say 2, 4, and 6) in three columns

    Started by H28Sailor‎, 12-04-2017 07:31 PM
    sumproduct
    • 1,255
    Last Post: 12-06-2017 07:28 AM
    by samba_ravi  Go to last post

    Forum:
    Excel General

  29. [SOLVED] Conditional SUMPRODUCT with blanks on different tab

    Started by wizadele14‎, 11-09-2017 07:02 AM
    blanks, month, sumproduct, value error, year 1 Attachment(s)
    • 705
    Last Post: 11-09-2017 10:53 AM
    by cbatrody  Go to last post

    Forum:
    Excel Formulas & Functions

  30. How to sumproduct cell arrays?

    Started by hpr0009‎, 10-28-2017 11:08 PM
    #value error, array constant, sumproduct, sumproduct #value! error
    • 754
    Last Post: 11-04-2017 02:20 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  31. rearrange database like dataset into table for large dataset better option INDEX MATCH

    Started by ryanbirk‎, 10-19-2017 11:20 PM
    fast, index, match, optimize, sumproduct 3 Attachment(s)
    • 936
    Last Post: 10-20-2017 12:40 AM
    by benishiryo  Go to last post

    Forum:
    Excel General

  32. [SOLVED] sumproduct exclude header

    Started by ZedaG‎, 10-17-2017 09:06 AM
    headers, sumproduct
    • 1,816
    Last Post: 10-17-2017 10:01 AM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] SUM only cells that contain odd numbers.

    Started by dzugan‎, 10-10-2017 07:29 PM
    sumif, sumproduct 1 Attachment(s)
    • 2,935
    Last Post: 10-11-2017 04:26 PM
    by mjr veverka  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Sumproduct W/Offset to Create a Rolling Average for Filtered Cells

    Started by gtnewberry‎, 10-04-2017 07:24 AM
    moving average, offset, sumproduct 1 Attachment(s)
    • 1,930
    Last Post: 10-05-2017 11:41 AM
    by daddylonglegs  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Help with combining 2 formulas

    Started by 900867‎, 09-28-2017 05:07 AM
    countifs, excel, formula, sumproduct 2 Attachment(s)
    • 623
    Last Post: 09-28-2017 08:31 PM
    by 900867  Go to last post

    Forum:
    Excel Formulas & Functions

Results 211 to 245 of 791
Page 7 of 23 FirstFirst 4 5 6 7 8 9 10

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1