sumproduct - Search Results - Excel Help Forum

[SOLVED] Sumproduct v Count IFs (or both)

Started by Matt1998‎, 04-23-2015 09:18 AM

3

611

Last Post By:: Last Post: 04-23-2015 09:59 AM; by bhenlee

Forum:
Excel Formulas & Functions

SUMPRODUCT Formula to exclude a criteria but include a similar criteria.

Started by insanebe‎, 04-21-2015 05:21 AM

3

924

Last Post By:: Last Post: 04-21-2015 07:45 AM; by daddylonglegs

Forum:
Excel General

[SOLVED] NETWORKDAYS + SUMPRODUCT Formula

Started by guibro‎, 04-09-2015 06:26 PM

33

3,265

Last Post By:: Last Post: 04-20-2015 12:33 PM; by guibro

Forum:
Excel Formulas & Functions

count if less than 5 & assign new numbering order

Started by tabkaz‎, 03-31-2015 05:53 AM

7

751

Last Post By:: Last Post: 04-02-2015 03:31 PM; by Pete_UK

Forum:
Excel Formulas & Functions

[SOLVED] Counting in Multiple Columns

Started by omnomster‎, 03-27-2015 08:24 PM

6

680

Last Post By:: Last Post: 03-27-2015 09:07 PM; by omnomster

Forum:
Excel Formulas & Functions

Too Many Sumproducts Freezing Up Excel?

Started by nila.khurana‎, 03-24-2015 01:29 AM

3

1,437

Last Post By:: Last Post: 03-24-2015 10:48 AM; by FDibbins

Forum:
Excel General

Conditional formatting rule to see if any booking dates overlap

Started by lawrencef‎, 03-23-2015 11:55 PM

conditional formatting, excel, excel 2007, sumproduct

2

1,503

Last Post By:: Last Post: 03-25-2015 01:08 AM; by lawrencef

Forum:
Excel Formulas & Functions

Struggling with SUMPRODUCT when matching "time between" values

Started by designergav‎, 03-20-2015 11:46 AM

4

721

Last Post By:: Last Post: 03-20-2015 01:07 PM; by FDibbins

Forum:
Excel Formulas & Functions

[SOLVED] Adding the values of a column after meeting criterion

Started by Mirell‎, 03-17-2015 08:51 PM

1

535

Last Post By:: Last Post: 03-18-2015 12:23 AM; by FDibbins

Forum:
Excel Formulas & Functions

[SOLVED] adding values after looking & matching day & time condition from another sheet

Started by tabkaz‎, 03-16-2015 10:45 AM

index, lookup, match and index, sumif and formula, sumproduct

6

782

Last Post By:: Last Post: 03-20-2015 07:51 AM; by tabkaz

Forum:
Excel Formulas & Functions

[SOLVED] sumproduct Or sumifs on multiple criteria matching day & time

Started by tabkaz‎, 03-16-2015 03:35 AM

index, match & indirect, offset, sumif, sumproduct

9

1,556

Last Post By:: Last Post: 03-16-2015 05:45 AM; by Jacc

Forum:
Excel Formulas & Functions

[SOLVED] Calculate Days Worked with Criteria

Started by nickmessick1‎, 03-13-2015 04:11 PM

array, dates calculation, macro, sumproduct

2

743

Last Post By:: Last Post: 03-13-2015 04:53 PM; by nickmessick1

Forum:
Excel General

SUMIF with row and column conditions

Started by edsdingis‎, 03-10-2015 04:54 PM

5

973

Last Post By:: Last Post: 03-11-2015 03:06 PM; by Jonmo1

Forum:
Excel Formulas & Functions

[SOLVED] Combining SUMPRODUCT and MAX

Started by DeZeeuw2‎, 03-09-2015 04:28 PM

7

5,772

Last Post By:: Last Post: 03-10-2015 01:06 PM; by DeZeeuw2

Forum:
Excel Formulas & Functions

[SOLVED] Need a SUMPRODUCT/SUMIF/INDEX/MATCH array formula. Please Help!!

Started by TheClaw2323‎, 03-06-2015 04:52 AM

2

2,028

Last Post By:: Last Post: 03-06-2015 01:34 PM; by Czeslaw

Forum:
Excel Formulas & Functions

SUMPRODUCT with INDEX MATCH help

Started by tozjerimiah‎, 03-05-2015 09:28 PM

1

727

Last Post By:: Last Post: 03-06-2015 09:53 AM; by Pepe Le Mokko

Forum:
Excel Formulas & Functions

SUM INDEX MATCH or SUMPRODUCT for Multiple Values

Started by dubasteins‎, 03-04-2015 04:05 PM

3

1,136

Last Post By:: Last Post: 03-04-2015 04:50 PM; by Jonmo1

Forum:
Excel Formulas & Functions

SUMPRODUCT expression for variable multipliers?

Started by ExcelDreamer‎, 03-03-2015 07:07 AM

3

760

Last Post By:: Last Post: 03-03-2015 07:31 AM; by oeldere

Forum:
Excel Formulas & Functions

SUMPRODUCT with more than one condition

Started by nolodani‎, 02-26-2015 04:11 PM

6

529

Last Post By:: Last Post: 02-26-2015 05:02 PM; by nolodani

Forum:
Excel Formulas & Functions

Formula to count specific items in a filtered table

Started by pr1nce‎, 02-20-2015 01:43 PM

1

627

Last Post By:: Last Post: 02-20-2015 07:23 PM; by jeversf

Forum:
Excel Formulas & Functions

sumif formula

Started by Jwildcat‎, 02-14-2015 02:01 AM

5

746

Last Post By:: Last Post: 02-14-2015 03:11 AM; by MarvinP

Forum:
Excel General

Counting number of cells that fall in a particular month.

Started by thekid22‎, 02-10-2015 10:21 PM

2

793

Last Post By:: Last Post: 02-10-2015 11:40 PM; by thekid22

Forum:
Excel Formulas & Functions

VBA needed with calculating value using multiple variables (sumproduct)

Started by TomW123‎, 02-09-2015 01:22 PM

0

371

Last Post By:: Last Post: 02-09-2015 01:22 PM; by TomW123

Forum:
Excel Programming / VBA / Macros

Index & Match use with Sumproduct and Arrays.

Started by robwebber‎, 02-07-2015 01:29 PM

2

979

Last Post By:: Last Post: 02-07-2015 02:24 PM; by robwebber

Forum:
Excel Formulas & Functions

[SOLVED] Counting multiple criteria in multiple columns

Started by jimbosi‎, 02-06-2015 05:40 PM

19

1,774

Last Post By:: Last Post: 03-22-2015 02:34 PM; by XOR LX

Forum:
Excel Formulas & Functions

[SOLVED] SUMIFS,INDEX, MATCH, OFFSET COUNTA / SUMPRODUCT? Multiple criteria across multiple sheets.

Started by TheKlaw‎, 02-06-2015 02:09 AM

counta, index, match, offset, sumproduct

5

3,888

Last Post By:: Last Post: 02-06-2015 08:44 PM; by TheKlaw

Forum:
Excel Formulas & Functions

Sumproduct,index,match

Started by TheKlaw‎, 02-04-2015 01:51 AM

9

2,386

Last Post By:: Last Post: 02-08-2015 06:13 PM; by TheKlaw

Forum:
Excel Formulas & Functions

Can you find the quartile of an array based on a condition and using only visible cells??

Started by Dsellman‎, 01-23-2015 08:23 AM

autofilter, quartile, subtotal filter, sumproduct, sumproduct for filtering

1

2,799

Last Post By:: Last Post: 01-23-2015 12:36 PM; by Dsellman

Forum:
Excel Formulas & Functions

[SOLVED] Sumifs returning #value on closed workbook

Started by 360Petty‎, 01-16-2015 04:13 PM

#value, closed workbook, sumif, sumproduct

4

12,346

Last Post By:: Last Post: 01-20-2015 07:05 AM; by 360Petty

Forum:
Excel Formulas & Functions

Using INDIRECT Function with SUMPRODUCT

Started by vba_madness‎, 01-16-2015 08:12 AM

4

1,488

Last Post By:: Last Post: 01-16-2015 09:19 AM; by vba_madness

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct or Sumifs

Started by adamsc57‎, 01-15-2015 08:09 PM

3

785

Last Post By:: Last Post: 01-15-2015 09:10 PM; by adamsc57

Forum:
Excel Formulas & Functions

Count number of Dates in a range that match Year and month

Started by the_penfool‎, 01-13-2015 11:37 AM

2

1,034

Last Post By:: Last Post: 01-13-2015 11:49 AM; by Kaper

Forum:
Excel Formulas & Functions

SumProduct N/A Error, Quarterly Average, Running Average, From and to Userform

Started by Sorjas‎, 01-11-2015 07:46 PM

9

1,303

Last Post By:: Last Post: 01-18-2015 07:40 PM; by Sorjas

Forum:
Excel Programming / VBA / Macros

Counting uniques

Started by mglon‎, 12-17-2014 07:32 AM

32

1,812

Last Post By:: Last Post: 12-18-2014 10:40 AM; by XOR LX

Forum:
Excel Formulas & Functions

[SOLVED] Check if sumproduct array contains only unique values

Started by gutkinma‎, 12-12-2014 05:41 AM

5

1,025

Last Post By:: Last Post: 12-12-2014 06:53 AM; by XOR LX

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds; generated 1 minute(s) ago.

[SOLVED] Sumproduct v Count IFs (or both)

SUMPRODUCT Formula to exclude a criteria but include a similar criteria.

[SOLVED] NETWORKDAYS + SUMPRODUCT Formula

count if less than 5 & assign new numbering order

[SOLVED] Counting in Multiple Columns

Too Many Sumproducts Freezing Up Excel?

Conditional formatting rule to see if any booking dates overlap

Struggling with SUMPRODUCT when matching "time between" values

[SOLVED] Adding the values of a column after meeting criterion

[SOLVED] adding values after looking & matching day & time condition from another sheet

[SOLVED] sumproduct Or sumifs on multiple criteria matching day & time

[SOLVED] Calculate Days Worked with Criteria

SUMIF with row and column conditions

[SOLVED] Combining SUMPRODUCT and MAX

[SOLVED] Need a SUMPRODUCT/SUMIF/INDEX/MATCH array formula. Please Help!!

SUMPRODUCT with INDEX MATCH help

SUM INDEX MATCH or SUMPRODUCT for Multiple Values

SUMPRODUCT expression for variable multipliers?

SUMPRODUCT with more than one condition

Formula to count specific items in a filtered table

sumif formula

Counting number of cells that fall in a particular month.

VBA needed with calculating value using multiple variables (sumproduct)

Index & Match use with Sumproduct and Arrays.

[SOLVED] Counting multiple criteria in multiple columns

[SOLVED] SUMIFS,INDEX, MATCH, OFFSET COUNTA / SUMPRODUCT? Multiple criteria across multiple sheets.

Sumproduct,index,match

Can you find the quartile of an array based on a condition and using only visible cells??

[SOLVED] Sumifs returning #value on closed workbook

Using INDIRECT Function with SUMPRODUCT

[SOLVED] Sumproduct or Sumifs

Count number of Dates in a range that match Year and month

SumProduct N/A Error, Quarterly Average, Running Average, From and to Userform

Counting uniques

[SOLVED] Check if sumproduct array contains only unique values