sumproduct - Search Results - Excel Help Forum

Need help with Sumif or Sumproduct maybe for range of times to calculate

Started by chadboehne‎, 02-02-2017 05:55 PM

2

580

Last Post By:: Last Post: 02-02-2017 09:10 PM; by Pete_UK

Forum:
Excel General

[SOLVED] Sumproduct Indirect Formula

Started by ghostexcel‎, 01-23-2017 06:12 AM

1

1,889

Last Post By:: Last Post: 01-23-2017 06:21 AM; by etaf

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct, sumif and indirect functions not working

Started by stillyours786‎, 12-28-2016 02:22 AM

indirect, multiple sheets sum, sumif, sumifs, sumproduct

10

4,079

Last Post By:: Last Post: 12-28-2016 06:01 AM; by stillyours786

Forum:
Excel Formulas & Functions

[SOLVED] Using SUMPRODUCT to display Trends on a Weekday basis

Started by anaschiliro‎, 12-22-2016 12:35 PM

3

698

Last Post By:: Last Post: 12-23-2016 09:55 AM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] How to use SUMPRODUCT instead of COUNT IF

Started by moneypennie21‎, 12-20-2016 01:08 PM

6

1,399

Last Post By:: Last Post: 02-14-2017 12:09 PM; by Pete_UK

Forum:
Excel Formulas & Functions

Using sumproduct when array contains some cells with text

Started by Manwithaplan‎, 12-16-2016 03:24 AM

9

1,670

Last Post By:: Last Post: 12-17-2016 01:15 AM; by samba_ravi

Forum:
Excel General

Help counting occurrence of partial number matches in column of numbers, based on criteria

Started by rhogsett‎, 12-06-2016 02:35 PM

7

885

Last Post By:: Last Post: 12-08-2016 04:35 PM; by rhogsett

Forum:
Excel Programming / VBA / Macros

Sum Product not working as expected

Started by hawaean‎, 12-03-2016 03:35 PM

find text, match cell value, multiple criteria, sumproduct

2

780

Last Post By:: Last Post: 12-03-2016 04:15 PM; by Richard Buttrey

Forum:
Excel General

Sumproduct from another sheet

Started by bsquad‎, 12-02-2016 03:32 PM

1

804

Last Post By:: Last Post: 12-02-2016 03:43 PM; by PCI

Forum:
Excel Programming / VBA / Macros

Sumproduct by month that excludes text

Started by rkd101b‎, 11-22-2016 04:19 PM

1

522

Last Post By:: Last Post: 11-22-2016 04:25 PM; by BadlySpelledBuoy

Forum:
Excel General

[SOLVED] SUMPRODUCT top 'x' percent of rows

Started by bsquad‎, 11-22-2016 03:44 PM

4

846

Last Post By:: Last Post: 11-22-2016 06:02 PM; by newdoverman

Forum:
Excel General

Countif +CountIF Alternative

Started by GabeGabe‎, 11-16-2016 08:15 PM

6

3,216

Last Post By:: Last Post: 11-19-2016 07:34 AM; by Jonmo1

Forum:
Excel Formulas & Functions

Check if any Other Cells in Column Start with Same Text and End with Different...

Started by WaylettChris‎, 11-11-2016 03:57 AM

left, starts with same text, sumif, sumproduct

1

523

Last Post By:: Last Post: 11-11-2016 04:52 AM; by JohnTopley

Forum:
Excel Formulas & Functions

SUMPRODUCT array formula doesn't recognize Array 5

Started by trstew‎, 11-08-2016 04:27 PM

array, closed workbook, sumifs, sumproduct

9

932

Last Post By:: Last Post: 11-08-2016 05:01 PM; by trstew

Forum:
Excel Formulas & Functions

[SOLVED] need 2 range to work with 1 criteria in the formula

Started by exceltriumph‎, 10-25-2016 10:18 AM

4

496

Last Post By:: Last Post: 10-25-2016 10:52 AM; by exceltriumph

Forum:
Excel Formulas & Functions

Sum Product (excluding a row)

Started by batchy‎, 10-21-2016 08:11 AM

6

3,005

Last Post By:: Last Post: 10-21-2016 10:11 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT showing #VALUE - Can't understand why it won't work

Started by vkz7hxy‎, 10-12-2016 08:24 AM

#value, excel, expert, formula, sumproduct

3

749

Last Post By:: Last Post: 10-12-2016 08:36 AM; by NBVC

Forum:
Excel Formulas & Functions

Count Day and year

Started by cull0507‎, 09-25-2016 05:25 PM

4

703

Last Post By:: Last Post: 09-26-2016 12:47 PM; by cull0507

Forum:
Excel Formulas & Functions

Index/Match if Indexed is greater than 7 or Sumproduct/Mod/Column (?)

Started by Franky alta‎, 09-24-2016 09:51 PM

/mod/column, index/match if indexed, is greater than, sumproduct

1

643

Last Post By:: Last Post: 09-25-2016 02:58 AM; by Glenn Kennedy

Forum:
Excel General

INDEX, MATCH, LARGE and/or SUMIF/SUMPRODUCT

Started by bsquad‎, 09-23-2016 04:49 PM

1

1,059

Last Post By:: Last Post: 09-23-2016 05:01 PM; by JBeaucaire

Forum:
Excel Formulas & Functions

Help with Sumproduct?

Started by SashaFierce14‎, 09-19-2016 05:49 PM

3

429

Last Post By:: Last Post: 09-20-2016 07:16 AM; by Tony Valko

Forum:
Excel Formulas & Functions

SUMIFS for 2 Variables (horizontal and vertical) YTD Sales

Started by EmileEA‎, 09-13-2016 09:05 AM

3

2,299

Last Post By:: Last Post: 09-13-2016 03:17 PM; by SharmaneRomeo

Forum:
Excel General

[SOLVED] Sumproduct using range as criteria to compare another range

Started by lukihnio‎, 08-24-2016 03:40 PM

5

1,407

Last Post By:: Last Post: 08-25-2016 11:07 AM; by Jonmo1

Forum:
Excel Formulas & Functions

Pulling rate from a table using two variables using SUMPRODUCT, INDEX, MATCH

Started by uffda1‎, 08-14-2016 08:15 PM

9

809

Last Post By:: Last Post: 08-15-2016 12:29 PM; by uffda1

Forum:
Excel Formulas & Functions

SUMPRODUCT, multiple criteria including ranges that are listed horozontally

Started by Manwithaplan‎, 08-04-2016 10:45 PM

7

624

Last Post By:: Last Post: 08-05-2016 12:51 AM; by FlameRetired

Forum:
Excel Formulas & Functions

Issue with sumproduct/ countifs in regards finding certain words in date range

Started by airedale360‎, 07-25-2016 05:42 PM

countif, countifs, date and range, sumproduct

4

580

Last Post By:: Last Post: 07-25-2016 08:02 PM; by Tony Valko

Forum:
Excel Formulas & Functions

Restaurant Schedule Using SUMPRODUCT & COUNTIF Formula. Almost Done so PLEASE ADVISE!!

Started by colton14‎, 07-25-2016 11:30 AM

countif, formula, schedule, shift, sumproduct

4

823

Last Post By:: Last Post: 07-25-2016 05:57 PM; by colton14

Forum:
Excel General

Need SUMPRODUCT/ SUMIF formula to sum each cell once not dupe if text contains 2 criteria

Started by lebatch‎, 07-20-2016 07:20 AM

isnumber, sumif, sumif and formula, sumproduct

9

1,178

Last Post By:: Last Post: 07-21-2016 07:03 AM; by xlnitwit

Forum:
Excel Formulas & Functions

[SOLVED] Sum certain cells in certain columns on multiple worksheets

Started by Uomoviso‎, 07-17-2016 07:32 AM

index, indirect, multiple worksheets, sumif, sumproduct

5

784

Last Post By:: Last Post: 07-20-2016 06:51 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] Exclude cells containing text from SUMPRODUCT function

Started by Uomoviso‎, 07-15-2016 09:32 AM

5

2,950

Last Post By:: Last Post: 07-17-2016 09:20 AM; by Tony Valko

Forum:
Excel Formulas & Functions

Calculating revenue by month using fixed rate per day between 2 dates - SUMPRODUCT ?

Started by kupe‎, 07-14-2016 05:54 AM

3

710

Last Post By:: Last Post: 07-14-2016 08:41 AM; by JeteMc

Forum:
Excel Formulas & Functions

SUMPRODUCT using INDIRECT function

Started by Manwithaplan‎, 07-07-2016 01:45 AM

indirect, multiple worksheets, sumproduct

15

2,493

Last Post By:: Last Post: 07-07-2016 03:26 AM; by humdingaling

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct({Array_1},{VLookUp(Array_2, Some_Range, Column_Num)})

Started by jewelsharma‎, 07-01-2016 01:26 AM

7

812

Last Post By:: Last Post: 07-04-2016 09:05 PM; by FlameRetired

Forum:
Excel Formulas & Functions

[SOLVED] OR with SUMPRODUCT

Started by BobTheRocker‎, 06-28-2016 04:14 AM

6

755

Last Post By:: Last Post: 06-28-2016 05:25 AM; by Tony Valko

Forum:
Excel Formulas & Functions

Sumproduct conditioning on the first characters

Started by Orongo‎, 06-16-2016 03:59 AM

5

577

Last Post By:: Last Post: 06-17-2016 08:27 AM; by Orongo

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

Need help with Sumif or Sumproduct maybe for range of times to calculate

[SOLVED] Sumproduct Indirect Formula

[SOLVED] Sumproduct, sumif and indirect functions not working

[SOLVED] Using SUMPRODUCT to display Trends on a Weekday basis

[SOLVED] How to use SUMPRODUCT instead of COUNT IF

Using sumproduct when array contains some cells with text

Help counting occurrence of partial number matches in column of numbers, based on criteria

Sum Product not working as expected

Sumproduct from another sheet

Sumproduct by month that excludes text

[SOLVED] SUMPRODUCT top 'x' percent of rows

Countif +CountIF Alternative

Check if any Other Cells in Column Start with Same Text and End with Different...

SUMPRODUCT array formula doesn't recognize Array 5

[SOLVED] need 2 range to work with 1 criteria in the formula

Sum Product (excluding a row)

[SOLVED] SUMPRODUCT showing #VALUE - Can't understand why it won't work

Count Day and year

Index/Match if Indexed is greater than 7 or Sumproduct/Mod/Column (?)

INDEX, MATCH, LARGE and/or SUMIF/SUMPRODUCT

Help with Sumproduct?

SUMIFS for 2 Variables (horizontal and vertical) YTD Sales

[SOLVED] Sumproduct using range as criteria to compare another range

Pulling rate from a table using two variables using SUMPRODUCT, INDEX, MATCH

SUMPRODUCT, multiple criteria including ranges that are listed horozontally

Issue with sumproduct/ countifs in regards finding certain words in date range

Restaurant Schedule Using SUMPRODUCT & COUNTIF Formula. Almost Done so PLEASE ADVISE!!

Need SUMPRODUCT/ SUMIF formula to sum each cell once not dupe if text contains 2 criteria

[SOLVED] Sum certain cells in certain columns on multiple worksheets

[SOLVED] Exclude cells containing text from SUMPRODUCT function

Calculating revenue by month using fixed rate per day between 2 dates - SUMPRODUCT ?

SUMPRODUCT using INDIRECT function

[SOLVED] Sumproduct({Array_1},{VLookUp(Array_2, Some_Range, Column_Num)})

[SOLVED] OR with SUMPRODUCT

Sumproduct conditioning on the first characters