sumproduct - Search Results - Excel Help Forum

SUMPRODUCT Working with Array

Started by antonywijesinghe‎, 11-01-2018 02:03 AM

7

622

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

Forum:
Excel Formulas & Functions

SumIf or SumProduct Formula to sum up totals based on a vertical and horizontal criteria

Started by jkinnick‎, 10-31-2018 03:07 PM

6

1,302

Last Post By:: Last Post: 11-03-2018 04:50 AM; by Amritabansal31

Forum:
Excel Formulas & Functions

Use boolean operator by referring to the cell address

Started by RJK‎, 10-26-2018 06:05 PM

6

603

Last Post By:: Last Post: 11-06-2018 05:48 AM; by Pete_UK

Forum:
Excel General

[SOLVED] Partial duplicate - Sumproduct VBA Help!

Started by Kanage‎, 10-23-2018 09:31 AM

7

484

Last Post By:: Last Post: 10-23-2018 11:09 AM; by rorya

Forum:
Excel Programming / VBA / Macros

SUMPRODUCT using 2 criteria in the same column at random intervals

Started by Manwithaplan‎, 10-15-2018 01:06 AM

criteria, random intervals, same column, sumproduct

5

3,902

Last Post By:: Last Post: 10-15-2018 07:32 PM; by FlameRetired

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct challenge

Started by mrsak87‎, 10-09-2018 08:05 AM

10

729

Last Post By:: Last Post: 10-09-2018 12:09 PM; by mrsak87

Forum:
Excel Formulas & Functions

lookup functionality of Sumproduct function

Started by Maths333‎, 10-05-2018 01:15 PM

0

354

Last Post By:: Last Post: 10-05-2018 01:15 PM; by Maths333

Forum:
Excel General

Time sensitive - need help fixing this formula

Started by colin heslop‎, 10-02-2018 09:07 AM

index and sum, multiple workbooks, sumif, sumproduct

5

502

Last Post By:: Last Post: 10-02-2018 10:27 AM; by dominicb

Forum:
Excel Formulas & Functions

[SOLVED] Error: Source Not Found Every Time I Open Excel Workbook

Started by whahmira‎, 09-20-2018 10:55 AM

2

855

Last Post By:: Last Post: 09-20-2018 12:00 PM; by whahmira

Forum:
Excel Formulas & Functions

[SOLVED] Formula to reference cells from a closed workbook?

Started by whahmira‎, 09-19-2018 03:20 PM

5

575

Last Post By:: Last Post: 09-20-2018 12:00 PM; by whahmira

Forum:
Excel Formulas & Functions

Use SUMPRODUCT to calculate effort based on weighted risk probability

Started by dammyshaggs‎, 09-17-2018 05:21 PM

3

3,335

Last Post By:: Last Post: 09-17-2018 08:20 PM; by joeu2004

Forum:
Excel Formulas & Functions

SUMPRODUCT? or not

Started by TanjaC‎, 09-17-2018 11:51 AM

1

362

Last Post By:: Last Post: 09-17-2018 11:56 AM; by 63falcondude

Forum:
Excel General

[SOLVED] Unable to sumproduct based off text in cell

Started by mltryfireman‎, 09-02-2018 12:23 AM

6

466

Last Post By:: Last Post: 09-02-2018 04:08 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct, extract numbers within text

Started by scorps10‎, 08-28-2018 01:17 PM

10

910

Last Post By:: Last Post: 08-29-2018 01:23 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Subtotal "average" with criteria from another column

Started by soreno‎, 08-27-2018 02:37 PM

11

827

Last Post By:: Last Post: 08-27-2018 06:54 PM; by 63falcondude

Forum:
Excel Programming / VBA / Macros

Formula to count wild card text in one column that is less than 90 days old

Started by philalethes‎, 08-23-2018 03:49 PM

2

303

Last Post By:: Last Post: 08-23-2018 04:09 PM; by philalethes

Forum:
Excel Formulas & Functions

Using array formula to solve timing problem (CHALLENGING!!!)

Started by joekhub‎, 08-18-2018 02:55 PM

3

460

Last Post By:: Last Post: 08-19-2018 04:26 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

named range referenced in formula

Started by b3tt3rc4ll4n4ly3t3‎, 08-16-2018 09:48 PM

automatic calculations, formula, named range, sumproduct

5

447

Last Post By:: Last Post: 08-16-2018 10:35 PM; by b3tt3rc4ll4n4ly3t3

Forum:
Excel Formulas & Functions

[SOLVED] Counting distinct occurrences between two columns based on date

Started by SHUTTEHFACE‎, 08-10-2018 09:20 PM

30

1,948

Last Post By:: Last Post: 08-18-2018 09:45 AM; by AliGW

Forum:
Excel Formulas & Functions

Count cells if a range contains month of January and another range is greater than zero

Started by philalethes‎, 08-10-2018 04:16 PM

3

357

Last Post By:: Last Post: 08-10-2018 04:38 PM; by BadlySpelledBuoy

Forum:
Excel Formulas & Functions

[SOLVED] =SumProduct Question (i love this formula)

Started by tommystanek‎, 08-06-2018 02:52 PM

5

352

Last Post By:: Last Post: 08-06-2018 03:02 PM; by Pauleyb

Forum:
Excel Formulas & Functions

sum across multiple worksheets with data sitting in variable cells

Started by Unisbm‎, 08-03-2018 01:44 AM

index, match, multiple, sumif, sumproduct

6

567

Last Post By:: Last Post: 08-06-2018 12:39 AM; by FDibbins

Forum:
Excel Formulas & Functions

Help with sumproduct to count number of times an item appears in a list

Started by EdwardSnowden‎, 07-31-2018 10:52 AM

4

708

Last Post By:: Last Post: 07-31-2018 04:24 PM; by Sam Capricci

Forum:
Excel General

Count unique values with criteria and blanks and an average of maximum consecutive values

Started by mrsak87‎, 07-30-2018 10:01 AM

average if, count if, critera, sum if, sumproduct

2

1,026

Last Post By:: Last Post: 07-30-2018 02:21 PM; by dflak

Forum:
Excel General

Sum Hlookup results from multiple tabs with dynamic range

Started by stattohogg‎, 07-26-2018 09:55 AM

7

911

Last Post By:: Last Post: 07-26-2018 12:06 PM; by stattohogg

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT Issue (Counting Blank Cells)

Started by JPV88‎, 07-09-2018 12:30 PM

3

2,528

Last Post By:: Last Post: 07-09-2018 12:53 PM; by jason.b75

Forum:
Excel Formulas & Functions

[SOLVED] Counting amount of times capital word appears in list of rows

Started by mrsak87‎, 06-28-2018 11:52 AM

4

516

Last Post By:: Last Post: 06-29-2018 04:15 AM; by mrsak87

Forum:
Excel Formulas & Functions

Sumproduct needs optimization

Started by nehabansal82‎, 06-27-2018 03:13 PM

5

623

Last Post By:: Last Post: 06-27-2018 08:10 PM; by macropod

Forum:
Excel Formulas & Functions

[SOLVED] Filter countif problem

Started by grdnryn‎, 06-25-2018 11:27 AM

7

3,073

Last Post By:: Last Post: 06-27-2018 08:00 PM; by FlameRetired

Forum:
Excel General

[SOLVED] SUMPRODUCT Formula for Multiple Conditions/Colums

Started by ezlea1971‎, 06-13-2018 03:25 PM

6

429

Last Post By:: Last Post: 06-14-2018 09:27 AM; by modytrane

Forum:
Excel Formulas & Functions

[SOLVED] Counting Multiple fields in 1 column

Started by mrsak87‎, 06-06-2018 07:28 AM

5

481

Last Post By:: Last Post: 06-06-2018 10:08 AM; by mrsak87

Forum:
Excel Formulas & Functions

How to identify the cells from the sumproduct formula result

Started by CachimJ‎, 05-29-2018 12:51 PM

conditionalformatting, excel, excelformula, formula, sumproduct

1

509

Last Post By:: Last Post: 05-29-2018 01:22 PM; by FDibbins

Forum:
Excel Formulas & Functions

[SOLVED] SUM/INDEX/SUMPRODUCT array formula

Started by esbencito‎, 05-29-2018 02:31 AM

6

705

Last Post By:: Last Post: 05-29-2018 04:43 AM; by esbencito

Forum:
Excel General

[SOLVED] Trying to count number of occurances based on multiple named ranges.

Started by spangleyguitar‎, 05-23-2018 08:44 PM

array, count, countif, occurances, sumproduct

5

504

Last Post By:: Last Post: 05-24-2018 12:18 AM; by spangleyguitar

Forum:
Excel Formulas & Functions

Excel Attendance leave tracker

Started by utkarsh1987‎, 05-18-2018 08:35 AM

2

1,788

Last Post By:: Last Post: 05-22-2018 08:35 AM; by JohnTopley

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

SUMPRODUCT Working with Array

SumIf or SumProduct Formula to sum up totals based on a vertical and horizontal criteria

Use boolean operator by referring to the cell address

[SOLVED] Partial duplicate - Sumproduct VBA Help!

SUMPRODUCT using 2 criteria in the same column at random intervals

[SOLVED] Sumproduct challenge

lookup functionality of Sumproduct function

Time sensitive - need help fixing this formula

[SOLVED] Error: Source Not Found Every Time I Open Excel Workbook

[SOLVED] Formula to reference cells from a closed workbook?

Use SUMPRODUCT to calculate effort based on weighted risk probability

SUMPRODUCT? or not

[SOLVED] Unable to sumproduct based off text in cell

[SOLVED] Sumproduct, extract numbers within text

[SOLVED] Subtotal "average" with criteria from another column

Formula to count wild card text in one column that is less than 90 days old

Using array formula to solve timing problem (CHALLENGING!!!)

named range referenced in formula

[SOLVED] Counting distinct occurrences between two columns based on date

Count cells if a range contains month of January and another range is greater than zero

[SOLVED] =SumProduct Question (i love this formula)

sum across multiple worksheets with data sitting in variable cells

Help with sumproduct to count number of times an item appears in a list

Count unique values with criteria and blanks and an average of maximum consecutive values

Sum Hlookup results from multiple tabs with dynamic range

[SOLVED] SUMPRODUCT Issue (Counting Blank Cells)

[SOLVED] Counting amount of times capital word appears in list of rows

Sumproduct needs optimization

[SOLVED] Filter countif problem

[SOLVED] SUMPRODUCT Formula for Multiple Conditions/Colums

[SOLVED] Counting Multiple fields in 1 column

How to identify the cells from the sumproduct formula result

[SOLVED] SUM/INDEX/SUMPRODUCT array formula

[SOLVED] Trying to count number of occurances based on multiple named ranges.

Excel Attendance leave tracker