sumproduct - Search Results - Excel Help Forum

[SOLVED] SUMPRODUCT Not working across separate workbooks #REF issue

Started by moneypennie21‎, 10-25-2022 09:38 AM

5

446

Last Post By:: Last Post: 10-26-2022 07:59 AM; by Fluff13

Forum:
Excel Formulas & Functions

how to extend sumproduct formula beyond the current range

Started by Gerti Ballia‎, 10-22-2022 11:27 AM

range, sumproduct, sumproduct #value! error

14

668

Last Post By:: Last Post: 10-22-2022 12:16 PM; by Sam Capricci

Forum:
Excel Formulas & Functions

[SOLVED] List of names to find in another list

Started by major_johnson‎, 10-19-2022 03:58 AM

22

610

Last Post By:: Last Post: 10-19-2022 06:33 AM; by major_johnson

Forum:
Excel General

Sum Product taking account of zeros

Started by Zarathrustra‎, 10-14-2022 10:49 AM

9

431

Last Post By:: Last Post: 10-16-2022 05:01 AM; by HansDouwe

Forum:
Excel Formulas & Functions

Sumproduct VALUE error

Started by scubadiver007‎, 10-11-2022 08:51 AM

5

375

Last Post By:: Last Post: 10-12-2022 09:26 AM; by josephteh

Forum:
Excel Formulas & Functions

[SOLVED] Using SUMPRODUCT to conditionally rank but not capturing everything

Started by ThurmanMay‎, 09-20-2022 05:54 AM

7

396

Last Post By:: Last Post: 09-20-2022 09:53 AM; by nick.williams

Forum:
Excel Formulas & Functions

[SOLVED] Counting based on three criteria

Started by Phlegon_of_Tralles‎, 09-14-2022 02:47 PM

2

522

Last Post By:: Last Post: 09-14-2022 03:40 PM; by Phlegon_of_Tralles

Forum:
Excel - New Users/Basics

Can a date and time can be matched between a start date/start time & finish date/time

Started by ProblemSolver‎, 09-13-2022 05:47 AM

index and match and if, lookup, sumproduct, time and date formula, xlookup

4

334

Last Post By:: Last Post: 09-13-2022 07:04 AM; by pjwhitfield

Forum:
Excel General

[SOLVED] COUNT / SUMPRODUCT with multiple criteria (wildcard "*")

Started by Konstantinos Apostol‎, 08-30-2022 10:42 AM

count if criteria, sumproduct, wild card matches

3

380

Last Post By:: Last Post: 08-30-2022 12:02 PM; by Fluff13

Forum:
Excel Formulas & Functions

Ranking Based on Multiple Criteria

Started by pawiair2‎, 07-05-2022 01:37 AM

10

563

Last Post By:: Last Post: 07-05-2022 11:32 AM; by oeldere

Forum:
Excel Formulas & Functions

Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

Started by chefanator‎, 05-30-2022 08:33 AM

4

635

Last Post By:: Last Post: 05-31-2022 07:49 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] SUMIFS by Specific Year in Date?

Started by Cardan‎, 04-22-2022 02:49 PM

8

424

Last Post By:: Last Post: 04-22-2022 04:13 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct for qtrly data

Started by TheRockHolger‎, 04-21-2022 11:01 PM

7

507

Last Post By:: Last Post: 04-22-2022 09:43 PM; by TheRockHolger

Forum:
Excel Formulas & Functions

[SOLVED] Conditional Formatting based on sum of values in multiple columns/rows

Started by mon33‎, 04-14-2022 04:50 AM

conditional, formatting, sum, sumifs, sumproduct

4

478

Last Post By:: Last Post: 06-14-2022 09:46 AM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Google Sheets: Combining SUMPRODUCT, AVERAGEIF and Wildcards in a single formula

Started by Sleurgh‎, 02-24-2022 03:19 AM

averageif, marketing, sumproduct, url, wildcard

7

1,217

Last Post By:: Last Post: 02-27-2022 10:16 PM; by Sleurgh

Forum:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

Adding the two lowest scores of 3 columns omitting zero

Started by ronjovi001‎, 02-21-2022 05:00 PM

multiple functions, race results, sumif, sumproduct

9

501

Last Post By:: Last Post: 02-22-2022 01:55 PM; by Limor_OP

Forum:
Excel Formulas & Functions

Need formula to count cells with text but omits duplicates

Started by klink1230‎, 02-16-2022 02:27 PM

countif, formula, macro, sumproduct, tally

9

492

Last Post By:: Last Post: 02-17-2022 06:14 PM; by Limor_OP

Forum:
Excel Formulas & Functions

INDEX + MATCH + OFFSET + SUMPRODUCT formula for Forecasting

Started by raviraval86‎, 02-12-2022 04:52 PM

index + match, offset formula, sumifs and and formula, sumproduct

4

526

Last Post By:: Last Post: 02-17-2022 02:23 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[SOLVED] Rank and Sort 2 Columns auto.

Started by myxlhlp‎, 02-11-2022 09:39 PM

9

546

Last Post By:: Last Post: 02-16-2022 04:21 AM; by myxlhlp

Forum:
Excel Formulas & Functions

SUMPRODUCT formula explanation

Started by ropaba‎, 02-07-2022 01:25 AM

sumproduct, sumproduct help, sumproduct in excel

1

391

Last Post By:: Last Post: 02-07-2022 01:33 AM; by XOR LX

Forum:
Excel Formulas & Functions

[SOLVED] Sumproduct produces #VALUE! if Row() is included in Offset funtion

Started by wisemaj‎, 02-06-2022 12:11 AM

#value! error, offset, row(), sumproduct

6

651

Last Post By:: Last Post: 02-07-2022 12:33 AM; by wisemaj

Forum:
Excel Formulas & Functions

Finding multiple criteria in nth rows

Started by Silent Whale‎, 02-05-2022 02:33 PM

isnumber, mod, multiple criteria, sumproduct, timesheets

12

554

Last Post By:: Last Post: 02-07-2022 04:31 PM; by Silent Whale

Forum:
Excel Formulas & Functions

table formula sum product not working

Started by TheCoachHank‎, 02-03-2022 12:19 PM

sumproduct, sumproduct date range, table

6

1,334

Last Post By:: Last Post: 02-08-2022 11:33 AM; by JeteMc

Forum:
Excel Formulas & Functions

count across multiple columns with multiple criteria

Started by roksolid‎, 02-02-2022 06:23 AM

4

363

Last Post By:: Last Post: 02-02-2022 12:24 PM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] sumproduct to count multiple criteria (once per row)

Started by MikeDeButts‎, 01-24-2022 07:24 PM

4

372

Last Post By:: Last Post: 01-25-2022 07:20 AM; by MikeDeButts

Forum:
Excel General

add a criterion to SUMPRODUCT

Started by apompo21‎, 01-10-2022 01:10 PM

1

330

Last Post By:: Last Post: 01-10-2022 03:00 PM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

Count Overlapping Minutes from two ranges with multiple criteria

Started by PingpongMastser‎, 01-07-2022 12:13 AM

countifs, dates, formula, overlapping times, sumproduct

2

411

Last Post By:: Last Post: 01-07-2022 11:26 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[SOLVED] SUMPRODUCT with conditions

Started by cableghost‎, 01-01-2022 02:25 AM

4

466

Last Post By:: Last Post: 01-03-2022 04:31 PM; by cableghost

Forum:
Excel Formulas & Functions

Ranking with SUMPRODUCT

Started by Sakrammentum‎, 12-26-2021 10:25 PM

6

682

Last Post By:: Last Post: 12-31-2021 02:16 PM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] summing a value across multiple sheets

Started by lorcapulpi‎, 12-19-2021 12:14 PM

15

757

Last Post By:: Last Post: 12-20-2021 12:11 PM; by AliGW

Forum:
Excel Formulas & Functions

SUMPRODUCT and CONCATENATE ignoring duplicates

Started by Nexus2‎, 11-10-2021 12:15 PM

1

461

Last Post By:: Last Post: 11-10-2021 12:46 PM; by AliGW

Forum:
Excel General

[SOLVED] Vlookup Formula mixed with Sumproduct Formula Problem

Started by djameshenry30‎, 10-06-2021 02:51 PM

2

406

Last Post By:: Last Post: 10-07-2021 04:52 AM; by wk9128

Forum:
Excel Formulas & Functions

SUMPRODUCT & IF Statement Help!

Started by jk2391‎, 09-14-2021 10:16 AM

date, if statement, sumproduct, timeline

2

553

Last Post By:: Last Post: 09-15-2021 01:52 AM; by FDibbins

Forum:
Excel General

[SOLVED] Breaking down a list of supplier invoices

Started by pkool‎, 08-27-2021 08:05 AM

13

631

Last Post By:: Last Post: 08-27-2021 09:46 AM; by josephteh

Forum:
Excel Formulas & Functions

SUMPRODUCT first N even rows in a column (with criteria) then AVERAGE

Started by jocknetstone‎, 08-27-2021 05:30 AM

8

601

Last Post By:: Last Post: 08-27-2021 11:21 PM; by janmorris

Forum:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

Search:

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

[SOLVED] SUMPRODUCT Not working across separate workbooks #REF issue

how to extend sumproduct formula beyond the current range

[SOLVED] List of names to find in another list

Sum Product taking account of zeros

Sumproduct VALUE error

[SOLVED] Using SUMPRODUCT to conditionally rank but not capturing everything

[SOLVED] Counting based on three criteria

Can a date and time can be matched between a start date/start time & finish date/time

[SOLVED] COUNT / SUMPRODUCT with multiple criteria (wildcard "*")

Ranking Based on Multiple Criteria

Count Rows Until A Certain Sum Value Is Reached based off addtl criteria

[SOLVED] SUMIFS by Specific Year in Date?

[SOLVED] Sumproduct for qtrly data

[SOLVED] Conditional Formatting based on sum of values in multiple columns/rows

[SOLVED] Google Sheets: Combining SUMPRODUCT, AVERAGEIF and Wildcards in a single formula

Adding the two lowest scores of 3 columns omitting zero

Need formula to count cells with text but omits duplicates

INDEX + MATCH + OFFSET + SUMPRODUCT formula for Forecasting

[SOLVED] Rank and Sort 2 Columns auto.

SUMPRODUCT formula explanation

[SOLVED] Sumproduct produces #VALUE! if Row() is included in Offset funtion

Finding multiple criteria in nth rows

table formula sum product not working

count across multiple columns with multiple criteria

[SOLVED] sumproduct to count multiple criteria (once per row)

add a criterion to SUMPRODUCT

Count Overlapping Minutes from two ranges with multiple criteria

[SOLVED] SUMPRODUCT with conditions

Ranking with SUMPRODUCT

[SOLVED] summing a value across multiple sheets

SUMPRODUCT and CONCATENATE ignoring duplicates

[SOLVED] Vlookup Formula mixed with Sumproduct Formula Problem

SUMPRODUCT & IF Statement Help!

[SOLVED] Breaking down a list of supplier invoices

SUMPRODUCT first N even rows in a column (with criteria) then AVERAGE