sumproduct - Search Results - Excel Help Forum

Shortening Calculation Time for Multiple Sumproducts

Started by sumproduct98‎, 09-03-2019 02:16 PM

0

364

Last Post By:: Last Post: 09-03-2019 02:16 PM; by sumproduct98

Forum:
Excel Formulas & Functions

Sumproduct with Left Function

Started by bees84‎, 07-31-2019 06:13 AM

12

753

Last Post By:: Last Post: 07-31-2019 09:33 AM; by TMS

Forum:
Excel General

Comparing (2) Rows of Data

Started by martybrodeur‎, 07-18-2019 05:33 PM

7

609

Last Post By:: Last Post: 07-19-2019 10:15 AM; by AliGW

Forum:
Excel Formulas & Functions

Count amounts for years within multiple columns

Started by moaaa‎, 07-16-2019 07:48 AM

2

380

Last Post By:: Last Post: 07-19-2019 08:37 AM; by JeteMc

Forum:
Hello..Introduce yourself

[SOLVED] Sumproduct with multiple variants - Help! I'm a newbie to sumproduct

Started by KIGeorge‎, 07-15-2019 08:48 PM

5

542

Last Post By:: Last Post: 07-16-2019 01:21 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Populate Calendar (names/Dates) with Names and Dates ranges as data

Started by picsou‎, 06-18-2019 10:24 AM

array formula, calendar, dates in formulae, index & match, sumproduct

8

751

Last Post By:: Last Post: 06-24-2019 10:37 PM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT using MOD to sum odd columns

Started by UltimateNeo‎, 05-24-2019 09:53 PM

8

1,487

Last Post By:: Last Post: 05-28-2019 08:21 PM; by UltimateNeo

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct formula when source file not open

Started by cshrestha‎, 05-22-2019 04:02 PM

4

1,792

Last Post By:: Last Post: 08-19-2019 11:29 AM; by cshrestha

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT failing with additional criteria of different range size

Started by zCJH4254‎, 05-22-2019 09:25 AM

3

460

Last Post By:: Last Post: 05-22-2019 10:43 AM; by zCJH4254

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT help needed to calculate rate (requires brain of a genius)

Started by Flora20‎, 05-09-2019 08:57 AM

5

471

Last Post By:: Last Post: 05-09-2019 02:12 PM; by Flora20

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT with date criteria that ignores blank cells

Started by moneypennie21‎, 03-19-2019 05:32 AM

2

462

Last Post By:: Last Post: 03-19-2019 05:57 AM; by moneypennie21

Forum:
Excel Formulas & Functions

[SOLVED] Count Matches Between 2 Columns

Started by DarrenPO‎, 03-11-2019 02:57 PM

5

604

Last Post By:: Last Post: 03-20-2019 03:20 PM; by DarrenPO

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT with dynamic range based entirely on individual cells

Started by Phil123456789‎, 03-08-2019 05:07 AM

extract characters, sumif critera from list, sumproduct, sumproduct conditinal sum, sumproduct formula modify

7

1,232

Last Post By:: Last Post: 03-08-2019 07:20 AM; by XLent

Forum:
Excel Formulas & Functions

SUMIF Formula Help

Started by drefiek‎, 03-05-2019 05:44 PM

3

449

Last Post By:: Last Post: 03-06-2019 08:04 AM; by jeffreybrown

Forum:
Excel Formulas & Functions

[SOLVED] inconsistent results with SUMPRODUCT

Started by moneypennie21‎, 02-14-2019 07:05 AM

8

1,033

Last Post By:: Last Post: 02-14-2019 08:39 AM; by moneypennie21

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT that ignores #N/A values

Started by moneypennie21‎, 02-13-2019 10:08 AM

2

852

Last Post By:: Last Post: 02-13-2019 11:12 AM; by moneypennie21

Forum:
Excel Formulas & Functions

[SOLVED] More efficient SUMPRODUCT formula?

Started by mrdomer07‎, 02-11-2019 04:18 PM

6

2,817

Last Post By:: Last Post: 02-13-2019 06:11 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT - Adding New Data Daily

Started by BigErnKingpin‎, 02-11-2019 08:11 AM

10

1,993

Last Post By:: Last Post: 02-14-2019 04:25 AM; by BigErnKingpin

Forum:
Excel Formulas & Functions

[SOLVED] Lookup specific worksheet and sum values within that meet criteria

Started by Elgin26‎, 01-31-2019 12:02 PM

indirect, lookup, multiple worksheets, sumif, sumproduct

4

516

Last Post By:: Last Post: 01-31-2019 12:46 PM; by Elgin26

Forum:
Excel Formulas & Functions

Goalseek on a sumproduct

Started by Kommandat‎, 01-29-2019 10:48 PM

formula, goal seek, solving equation, sumproduct

3

1,731

Last Post By:: Last Post: 01-30-2019 02:52 AM; by JKC-HK

Forum:
Excel Formulas & Functions

[SOLVED] SUMIF with wildcard

Started by _Dice_‎, 01-26-2019 10:20 AM

sum, sumif, sumifs, sumproduct, wildcard

6

752

Last Post By:: Last Post: 01-26-2019 10:58 AM; by _Dice_

Forum:
Excel Formulas & Functions

SumProduct of common range on dynamic number of duplicate sheets

Started by FrisoKoopman‎, 01-10-2019 09:06 AM

#value!, dynamic, public function, sumproduct

0

707

Last Post By:: Last Post: 01-10-2019 09:06 AM; by FrisoKoopman

Forum:
Excel Formulas & Functions

Countif? Sumproduct?

Started by liam_bettinson‎, 01-10-2019 06:28 AM

5

809

Last Post By:: Last Post: 01-11-2019 12:24 AM; by FDibbins

Forum:
Excel Formulas & Functions

[SOLVED] combine SUMPRODUCT & COUNTIFS

Started by acolbrantNMBS‎, 01-08-2019 10:30 AM

3

4,649

Last Post By:: Last Post: 01-08-2019 11:47 AM; by Bo_Ry

Forum:
Excel Formulas & Functions

Workbook efficiency from overuse of large sumproduct formulas

Started by mrsak87‎, 01-08-2019 06:07 AM

3

581

Last Post By:: Last Post: 01-08-2019 07:25 AM; by tim201110

Forum:
Excel Formulas & Functions

Counting # of instances based on 3 criteria. sumproduct?

Started by RubiksCuber‎, 12-26-2018 11:49 AM

array, countif, formula, matrix, sumproduct

4

512

Last Post By:: Last Post: 12-26-2018 12:27 PM; by Bo_Ry

Forum:
Excel Formulas & Functions

Sumproduct multiple ranges with multiple conditions

Started by lwcorp‎, 12-21-2018 06:02 AM

6

1,158

Last Post By:: Last Post: 12-22-2018 07:47 PM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Need to sum values based on set criteria: SUMIF, SUMPRODUCT or something else?

Started by Jonathan King‎, 12-20-2018 09:39 PM

countif, sumif and condition, sumproduct

4

503

Last Post By:: Last Post: 12-21-2018 06:44 AM; by Pete_UK

Forum:
Excel Formulas & Functions

Formula for tiered pricing

Started by brems‎, 12-11-2018 11:44 AM

1

495

Last Post By:: Last Post: 12-11-2018 12:02 PM; by Bo_Ry

Forum:
Excel Formulas & Functions

3D Sumif for non existent sheets

Started by learningbasics‎, 12-05-2018 04:13 PM

indirect, multiple sheet search, sumif, sumproduct

13

1,229

Last Post By:: Last Post: 12-07-2018 08:25 AM; by Richard Buttrey

Forum:
Excel General

Compute Sumproduct while Excluding product Variants

Started by Pneumz‎, 12-05-2018 01:56 PM

5

523

Last Post By:: Last Post: 12-11-2018 10:55 PM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Formula to count number of cells containing entered numbers but NOT a cell with =SUM()

Started by peculiar101‎, 11-21-2018 01:15 PM

18

738

Last Post By:: Last Post: 11-21-2018 05:54 PM; by peculiar101

Forum:
Excel Formulas & Functions

SUMPRODUCT in VBA

Started by lassebasse‎, 11-20-2018 08:35 AM

8

777

Last Post By:: Last Post: 11-20-2018 11:14 AM; by lassebasse

Forum:
Excel Programming / VBA / Macros

[SOLVED] COUNTIFS should not count hidden cells

Started by Tunne‎, 11-14-2018 02:55 AM

count "x", countifs, hidden cells, sumproduct

9

557

Last Post By:: Last Post: 11-15-2018 05:25 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

NETWORKDAYS inside SUMPRODUCT

Started by SHUTTEHFACE‎, 11-12-2018 02:46 PM

5

499

Last Post By:: Last Post: 11-12-2018 04:21 PM; by 63falcondude

Forum:
Excel General

Search:

Search: Replies Views Search took 0.01 seconds.

Shortening Calculation Time for Multiple Sumproducts

Sumproduct with Left Function

Comparing (2) Rows of Data

Count amounts for years within multiple columns

[SOLVED] Sumproduct with multiple variants - Help! I'm a newbie to sumproduct

[SOLVED] Populate Calendar (names/Dates) with Names and Dates ranges as data

[SOLVED] SUMPRODUCT using MOD to sum odd columns

[SOLVED] Sumproduct formula when source file not open

[SOLVED] SUMPRODUCT failing with additional criteria of different range size

[SOLVED] SUMPRODUCT help needed to calculate rate (requires brain of a genius)

[SOLVED] SUMPRODUCT with date criteria that ignores blank cells

[SOLVED] Count Matches Between 2 Columns

[SOLVED] SUMPRODUCT with dynamic range based entirely on individual cells

SUMIF Formula Help

[SOLVED] inconsistent results with SUMPRODUCT

[SOLVED] SUMPRODUCT that ignores #N/A values

[SOLVED] More efficient SUMPRODUCT formula?

[SOLVED] SUMPRODUCT - Adding New Data Daily

[SOLVED] Lookup specific worksheet and sum values within that meet criteria

Goalseek on a sumproduct

[SOLVED] SUMIF with wildcard

SumProduct of common range on dynamic number of duplicate sheets

Countif? Sumproduct?

[SOLVED] combine SUMPRODUCT & COUNTIFS

Workbook efficiency from overuse of large sumproduct formulas

Counting # of instances based on 3 criteria. sumproduct?

Sumproduct multiple ranges with multiple conditions

[SOLVED] Need to sum values based on set criteria: SUMIF, SUMPRODUCT or something else?

Formula for tiered pricing

3D Sumif for non existent sheets

Compute Sumproduct while Excluding product Variants

[SOLVED] Formula to count number of cells containing entered numbers but NOT a cell with =SUM()

SUMPRODUCT in VBA

[SOLVED] COUNTIFS should not count hidden cells

NETWORKDAYS inside SUMPRODUCT