Search:

Tag: sumproduct

Search: Search took 0.01 seconds.

1. Need a formula that calculates how many days in a given month between two given dates

• Replies: 5
• Views: 1,429
Last Post: 2020-02-21 04:57 PM
by p45cal

Forum:
Formulas

2. Sumproduct in Pivot Tables - can it be done?

• Replies: 1
• Views: 5,651
Last Post: 2018-11-12 11:52 AM
by JoePublic

Forum:
PivotTables

3. sum values based off matches from two ranges

• Replies: 9
• Views: 2,908
Last Post: 2018-11-10 04:40 PM
by ajko7

Forum:
Formulas

4. Search a data set and return adjacent cell values and sum them within one cell

• Replies: 3
• Views: 686
Last Post: 2018-09-28 06:58 PM
by JonnyBravo

Forum:
Formulas

5. Weighted Average Summary Table

• Replies: 1
• Views: 498
Last Post: 2018-09-27 08:15 PM
by NBVC

Forum:
Formulas

6. What is the best formula to use

• Replies: 2
• Views: 980
Last Post: 2018-03-20 01:36 AM
by imran999

Forum:
Formulas

7. Sumproduct with Elapsed Time Compared to Other Column

• Replies: 5
• Views: 1,351
Last Post: 2017-04-06 02:06 PM
by naridox

Forum:
Formulas

8. Sumproduct: Dates by year matched against certain terms, ignore blanks/text

• Replies: 6
• Views: 1,477
Last Post: 2017-03-27 07:27 PM
by naridox

Forum:
Formulas

9. Alternative solution to COUNTIFS required for multiple ranges of different sizes

• Replies: 1
• Views: 1,065
Last Post: 2017-01-24 06:48 AM
by Canapone

Forum:
Formulas

10. Need Help With Sumproduct

• Replies: 2
• Views: 1,390
Last Post: 2016-05-25 09:52 PM
by JSandfer
11. Count blanks, in a range defined by criteria outside range

• Replies: 2
• Views: 1,065
Last Post: 2016-05-17 08:40 AM
by AndrewPhoenix

Forum:
Formulas

12. SUMIFS for a certain number of matches in a column

• Replies: 2
• Views: 2,031
Last Post: 2014-08-26 08:29 AM
by wozbits

Forum:
Formulas

13. Using Excel to Solve for a Goal Rate on new Units Sold

• Replies: 0
• Views: 827
Last Post: 2013-07-21 11:28 PM
by randomwalk

Forum:
Formulas

14. Using SUMPRODUCT to show values like a pivot table

• Replies: 1
• Views: 2,505
Last Post: 2013-01-05 07:44 PM
by Bob Phillips

Forum:
Formulas

Results 1 to 14 of 15