sumproduct - Search Results - Excel Help Forum

Sumproduct produces #NUM! error, double unary operator seems to be failing

Started by #vlookup‎, 09-21-2017 12:49 PM

7

688

Last Post By:: Last Post: 09-21-2017 03:54 PM; by #vlookup

Forum:
Excel Formulas & Functions

[SOLVED] Excel VBA Countif for multiple criteria

Started by Simone Fick‎, 09-12-2017 05:29 PM

countif, criteria, excel & vba, formula, sumproduct

3

3,042

Last Post By:: Last Post: 09-12-2017 08:35 PM; by Maudibe

Forum:
Excel Programming / VBA / Macros

Sumproduct with matched column in multiple arrays

Started by Kevdog1000‎, 09-06-2017 06:25 PM

14

1,254

Last Post By:: Last Post: 09-10-2017 01:24 PM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[SOLVED] Sum Lookup from a 2nd table - SumIf and SumProduct(?)

Started by Bigglesuk‎, 09-05-2017 08:37 AM

5

602

Last Post By:: Last Post: 09-06-2017 04:05 PM; by Bigglesuk

Forum:
Excel Formulas & Functions

[SOLVED] MIN IF function across multiple worksheets

Started by Uomoviso‎, 09-04-2017 06:53 AM

14

2,389

Last Post By:: Last Post: 09-05-2017 09:57 AM; by leelnich

Forum:
Excel Formulas & Functions

Range of values meeting a range of criteria

Started by alex.diederich‎, 09-02-2017 07:43 AM

array, countif, countifs, multiple criteria, sumproduct

6

813

Last Post By:: Last Post: 09-03-2017 04:30 PM; by FlameRetired

Forum:
Excel General

[SOLVED] Formula to count projects that were active each month (COUNTIF/SUMPRODUCT)

Started by kelseygueldalewis‎, 08-29-2017 01:04 PM

6

1,909

Last Post By:: Last Post: 09-05-2017 02:36 PM; by JeteMc

Forum:
Excel Formulas & Functions

sumproduct with arrays of different size

Started by excellearner16‎, 08-22-2017 03:35 PM

1

1,297

Last Post By:: Last Post: 08-22-2017 04:32 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Sum every third cell formula

Started by Rellsunn‎, 08-21-2017 07:35 PM

3

604

Last Post By:: Last Post: 08-21-2017 09:37 PM; by Rellsunn

Forum:
Excel Formulas & Functions

[SOLVED] Find Avg of weighted values, dependent on multiple criteria, with weightings in 3rd table

Started by butterpouch‎, 08-16-2017 09:57 PM

multiple criteria, sumproduct, weighted average

6

824

Last Post By:: Last Post: 08-17-2017 10:41 AM; by butterpouch

Forum:
Excel Formulas & Functions

SUMPRODUCT incorrectly calculating price tiers

Started by awenner‎, 08-16-2017 11:18 AM

3

511

Last Post By:: Last Post: 08-16-2017 01:14 PM; by joeu2004

Forum:
Excel General

[SOLVED] Data identification, multiplication n summation

Started by Amolvijay‎, 08-03-2017 10:05 AM

2

570

Last Post By:: Last Post: 08-03-2017 12:00 PM; by Amolvijay

Forum:
Excel General

SUMPRODUCT + COUNTIF but exclude blanks

Started by finnvalor‎, 07-26-2017 03:04 PM

5

7,164

Last Post By:: Last Post: 07-26-2017 03:50 PM; by Jonmo1

Forum:
Excel Formulas & Functions

[SOLVED] Need count of unique text values in column

Started by kitpierce‎, 07-20-2017 08:33 PM

3

413

Last Post By:: Last Post: 07-21-2017 01:01 PM; by leelnich

Forum:
Excel Formulas & Functions

[SOLVED] Help me about Convert COUNTIF to SUMPRODUCT

Started by putritersenyum‎, 07-18-2017 06:32 PM

8

1,510

Last Post By:: Last Post: 07-19-2017 12:17 PM; by tim201110

Forum:
Excel Formulas & Functions

Calculating Division Records in Fantasy Baseball

Started by mvcasaz‎, 06-23-2017 05:09 PM

1

559

Last Post By:: Last Post: 06-23-2017 05:11 PM; by mvcasaz

Forum:
Excel Formulas & Functions

Counting with a referenced "or" criteria

Started by hawaean‎, 06-15-2017 03:47 PM

countifs, nested or, or condition, sumproduct

1

350

Last Post By:: Last Post: 06-15-2017 03:49 PM; by Jonmo1

Forum:
Excel Formulas & Functions

3-d conditional sum with both horizontal and vertical criteria

Started by JudoFlash‎, 06-06-2017 12:13 PM

3-d, conditional, sumif, sumifs, sumproduct

6

2,094

Last Post By:: Last Post: 06-07-2017 10:25 AM; by Bernie Deitrick

Forum:
Excel General

Adding a second exclusion to sumproduct formula

Started by TheGrinch1‎, 05-25-2017 11:23 AM

1

557

Last Post By:: Last Post: 05-25-2017 11:26 AM; by JBeaucaire

Forum:
Excel Formulas & Functions

[SOLVED] multiple conditions, within multiple conditions

Started by cvanoosbree‎, 05-25-2017 01:00 AM

multiple criteria, range, sum - range of cells, sumproduct

16

1,104

Last Post By:: Last Post: 05-26-2017 12:41 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT Exclusion Problem

Started by TheGrinch1‎, 05-24-2017 12:01 PM

4

519

Last Post By:: Last Post: 05-25-2017 05:11 AM; by TheGrinch1

Forum:
Excel Formulas & Functions

Using the same Data set from a subtotal formula to put into a sumproduct formula

Started by g_data2017‎, 05-18-2017 07:28 PM

28

1,376

Last Post By:: Last Post: 05-26-2017 08:17 PM; by FlameRetired

Forum:
Excel Formulas & Functions

SUMPRODUCT formula Criteria fix

Started by excelconditional‎, 05-17-2017 10:22 AM

3

461

Last Post By:: Last Post: 05-22-2017 10:53 AM; by excelconditional

Forum:
Excel Formulas & Functions

[SOLVED] Using Sumproduct in place of CountIf

Started by lbickford‎, 05-10-2017 03:21 PM

2

458

Last Post By:: Last Post: 05-10-2017 03:42 PM; by lbickford

Forum:
Excel Formulas & Functions

SUMPRODUCT and ARRAY with cell references/formulas

Started by fpennelli‎, 05-03-2017 11:58 AM

8

1,805

Last Post By:: Last Post: 08-10-2022 02:38 PM; by oeldere

Forum:
Excel Formulas & Functions

[SOLVED] Search Text String for Match in a Column of Key Words

Started by letsgobuffalo‎, 04-28-2017 01:41 PM

6

753

Last Post By:: Last Post: 04-29-2017 06:04 AM; by letsgobuffalo

Forum:
Excel Formulas & Functions

[SOLVED] Extracting numbers from text in cell range and summing them up using SUMPRODUCT

Started by Jakub2‎, 04-14-2017 06:53 AM

3

730

Last Post By:: Last Post: 04-14-2017 07:41 AM; by Jakub2

Forum:
Excel Formulas & Functions

Index match multiple results

Started by luke_reed‎, 04-07-2017 07:01 AM

4

655

Last Post By:: Last Post: 04-07-2017 08:06 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

SUMIF and VLOOKUP selected columns on separate sheet

Started by owl4life1867‎, 04-02-2017 02:35 PM

4

699

Last Post By:: Last Post: 04-02-2017 03:56 PM; by owl4life1867

Forum:
Excel Formulas & Functions

Calculating EWMA

Started by ewma‎, 04-02-2017 12:48 AM

4

1,321

Last Post By:: Last Post: 04-02-2017 01:22 AM; by ewma

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT with SUM nested, can it be done?

Started by rikkydik‎, 03-29-2017 02:18 PM

2

1,166

Last Post By:: Last Post: 03-29-2017 02:40 PM; by rikkydik

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct if?

Started by cchap‎, 03-22-2017 05:41 PM

8

751

Last Post By:: Last Post: 03-22-2017 09:53 PM; by Pete_UK

Forum:
Excel Formulas & Functions

[SOLVED] Calculating info in a column based on a "greater than" date & info in another column

Started by fpm2002‎, 02-26-2017 04:34 AM

countif, date as criteria, greater than, sumproduct

10

840

Last Post By:: Last Post: 03-06-2017 12:58 AM; by fpm2002

Forum:
Excel Formulas & Functions

[SOLVED] Count how many rows contain a number of matches with another

Started by Ichigo12‎, 02-17-2017 02:38 PM

5

528

Last Post By:: Last Post: 02-19-2017 03:49 PM; by FlameRetired

Forum:
Excel Formulas & Functions

Extracting HOUR from a timestamp in SUMIFS statement

Started by Darren Morgan‎, 02-10-2017 05:23 AM

finding hour element, multiple condition, sumif, sumproduct

7

1,815

Last Post By:: Last Post: 02-10-2017 06:16 AM; by sandy666

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

Sumproduct produces #NUM! error, double unary operator seems to be failing

[SOLVED] Excel VBA Countif for multiple criteria

Sumproduct with matched column in multiple arrays

[SOLVED] Sum Lookup from a 2nd table - SumIf and SumProduct(?)

[SOLVED] MIN IF function across multiple worksheets

Range of values meeting a range of criteria

[SOLVED] Formula to count projects that were active each month (COUNTIF/SUMPRODUCT)

sumproduct with arrays of different size

[SOLVED] Sum every third cell formula

[SOLVED] Find Avg of weighted values, dependent on multiple criteria, with weightings in 3rd table

SUMPRODUCT incorrectly calculating price tiers

[SOLVED] Data identification, multiplication n summation

SUMPRODUCT + COUNTIF but exclude blanks

[SOLVED] Need count of unique text values in column

[SOLVED] Help me about Convert COUNTIF to SUMPRODUCT

Calculating Division Records in Fantasy Baseball

Counting with a referenced "or" criteria

3-d conditional sum with both horizontal and vertical criteria

Adding a second exclusion to sumproduct formula

[SOLVED] multiple conditions, within multiple conditions

[SOLVED] SUMPRODUCT Exclusion Problem

Using the same Data set from a subtotal formula to put into a sumproduct formula

SUMPRODUCT formula Criteria fix

[SOLVED] Using Sumproduct in place of CountIf

SUMPRODUCT and ARRAY with cell references/formulas

[SOLVED] Search Text String for Match in a Column of Key Words

[SOLVED] Extracting numbers from text in cell range and summing them up using SUMPRODUCT

Index match multiple results

SUMIF and VLOOKUP selected columns on separate sheet

Calculating EWMA

[SOLVED] SUMPRODUCT with SUM nested, can it be done?

[SOLVED] Sumproduct if?

[SOLVED] Calculating info in a column based on a "greater than" date & info in another column

[SOLVED] Count how many rows contain a number of matches with another

Extracting HOUR from a timestamp in SUMIFS statement