sum and if - Search Results - Excel Help Forum

Calculate YTD with criteria

Started by varbergt‎, 12-22-2023 05:42 PM

8

366

Last Post By:: Last Post: 12-27-2023 06:38 PM; by Gregb11

Forum:
Excel Formulas & Functions

Adding cells related to search criteria

Started by jgwade99‎, 10-16-2023 08:20 PM

6

184

Last Post By:: Last Post: 10-16-2023 09:53 PM; by HansDouwe

Forum:
Excel General

Formula Not Displaying Negative Values Correctly

Started by Frankinstyyn‎, 08-04-2023 10:08 AM

16

899

Last Post By:: Last Post: 08-04-2023 12:34 PM; by JohnTopley

Forum:
Excel Formulas & Functions

Sum data based on criteria regarding another cell

Started by PhantomDraft‎, 02-15-2023 05:39 AM

3

221

Last Post By:: Last Post: 02-15-2023 04:50 PM; by CARACALLA

Forum:
Excel Formulas & Functions

How to sum multiple cells in a referenced sheet without typing said sheet name again

Started by scottwiebe‎, 07-21-2022 05:01 PM

3

289

Last Post By:: Last Post: 07-21-2022 06:07 PM; by TMS

Forum:
Excel Formulas & Functions

Summing data based on one criteria that could be found in multiple columns

Started by dion48064‎, 02-03-2022 08:58 AM

index, index & match, sum, sum and if, vlookup

33

1,064

Last Post By:: Last Post: 02-07-2022 08:23 AM; by dion48064

Forum:
Excel Formulas & Functions

Performing a function on a range of cells if a certain condition is met

Started by rafest‎, 10-23-2021 04:09 PM

4

355

Last Post By:: Last Post: 10-23-2021 04:31 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] Combing SUMIF SEARCH and XLookup

Started by Dustychops‎, 10-23-2021 10:56 AM

5

407

Last Post By:: Last Post: 10-23-2021 02:24 PM; by Fluff13

Forum:
Excel Formulas & Functions

How to change cells based upon a another cell

Started by knopp‎, 09-24-2021 08:09 AM

date, if statement, nested if statement, sum and if

6

555

Last Post By:: Last Post: 09-24-2021 09:46 AM; by knopp

Forum:
Excel Formulas & Functions

[SOLVED] Sumif specific value in ayear

Started by Excl3454‎, 05-04-2021 12:04 PM

2

410

Last Post By:: Last Post: 05-04-2021 12:17 PM; by Excl3454

Forum:
Excel Formulas & Functions

[SOLVED] Conditional Sum

Started by lacrimosus1028‎, 03-31-2021 03:15 AM

sum - range of cells, sum a column, sum and if, sum and if's, sum and ifs

3

620

Last Post By:: Last Post: 03-31-2021 03:54 AM; by Glenn Kennedy

Forum:
Excel General

[SOLVED] Count/Sum based on another column date range/value

Started by iqbal.88‎, 01-20-2021 07:16 AM

count and if, formula, function, sum and if

12

966

Last Post By:: Last Post: 01-31-2021 10:57 AM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Sum Functions/formula: selection for addition base off of colours

Started by Eline Verhoeven‎, 10-12-2020 04:25 AM

colour, formula, sum - range of cells, sum and if

5

1,031

Last Post By:: Last Post: 10-12-2020 11:07 AM; by Glenn Kennedy

Forum:
Outlook Formatting & Functions

[SOLVED] create sum out of a list based on activated options in 2 different lists

Started by moritz23‎, 08-12-2020 06:41 AM

3

421

Last Post By:: Last Post: 08-18-2020 11:44 AM; by José Augusto

Forum:
Excel Formulas & Functions

Summing values below cells that contain a specific text

Started by danielhoryu‎, 04-10-2020 10:05 AM

sum, sum a column, sum and if, sum and if's, total

5

562

Last Post By:: Last Post: 04-10-2020 12:47 PM; by TMS

Forum:
Excel Formulas & Functions

Hello!! Joined this forum to get some help on excel

Started by Snehith Moturi‎, 03-15-2020 03:16 AM

1

328

Last Post By:: Last Post: 03-15-2020 03:32 AM; by arlu1201

Forum:
Hello..Introduce yourself

SUMIF calculation needed

Started by Vijay457‎, 11-22-2019 03:31 AM

sum and if, sumif and and formula, sumif and condition, sumif and index and match

4

429

Last Post By:: Last Post: 11-22-2019 04:08 AM; by AliGW

Forum:
Excel Formulas & Functions

Sum days/hours between multiple dates in excel with criteria

Started by Abe1992‎, 08-22-2019 11:25 AM

first post, stock control, stock data, stock depletions, sum and if

5

573

Last Post By:: Last Post: 09-02-2019 10:29 PM; by JeteMc

Forum:
Excel Formulas & Functions

Sum of cells if 1 or more cells >0

Started by viscalana‎, 08-13-2019 05:34 AM

funtions, sum, sum - range of cells, sum and if

7

417

Last Post By:: Last Post: 08-13-2019 10:47 AM; by jason.b75

Forum:
Excel Formulas & Functions

[SOLVED] Estimated Quote value to be Zeroed where we have Net Sales figure in adjacent column

Started by BigErnKingpin‎, 08-01-2019 05:35 AM

7

460

Last Post By:: Last Post: 08-01-2019 06:31 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] sum, if column contains array of specific strings

Started by Mag2‎, 06-01-2019 03:28 PM

4

475

Last Post By:: Last Post: 06-02-2019 07:42 AM; by Fluff13

Forum:
Excel Formulas & Functions

Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

Started by belladws‎, 05-03-2019 07:54 AM

excel, ifstatement, pick list, sum and if

3

424

Last Post By:: Last Post: 05-03-2019 09:13 AM; by belladws

Forum:
Excel Formulas & Functions

[SOLVED] Give a number a different value when summed

Started by ReyDeSirenas‎, 03-07-2019 01:59 AM

7

488

Last Post By:: Last Post: 03-08-2019 07:23 PM; by jason.b75

Forum:
Excel Formulas & Functions

Distribution of values

Started by eclipsedmind‎, 01-23-2019 05:18 PM

distribution, distribution list, inventory allocation, match cell value, sum and if

1

576

Last Post By:: Last Post: 01-23-2019 06:00 PM; by FDibbins

Forum:
Excel Formulas & Functions

Sum a range of values related to a range in a different column.

Started by RTLab‎, 02-28-2018 06:48 PM

1

431

Last Post By:: Last Post: 02-28-2018 08:23 PM; by jeffreybrown

Forum:
Excel Formulas & Functions

Count Min Max & Sum

Started by Vcare‎, 10-24-2017 07:36 AM

4

609

Last Post By:: Last Post: 10-24-2017 07:58 AM; by Vcare

Forum:
Excel Formulas & Functions

[SOLVED] Multiple sumifs with variable conditions

Started by GFChristian‎, 10-24-2017 06:03 AM

4

548

Last Post By:: Last Post: 10-24-2017 06:15 AM; by 63falcondude

Forum:
Excel Formulas & Functions

Sum all above cells until you reach a blank cell

Started by vba-amateur‎, 10-09-2017 02:15 PM

dynamic array, dynamic cell references, sum - range of cells, sum a column, sum and if

4

1,161

Last Post By:: Last Post: 10-09-2017 04:18 PM; by leelnich

Forum:
Excel Programming / VBA / Macros

Create Sum based on IF statement formula?

Started by IndyRyan1‎, 05-15-2017 05:15 PM

average first x non blank, blank cell management, if statement formula, sum and if

1

579

Last Post By:: Last Post: 05-15-2017 05:25 PM; by FlameRetired

Forum:
Excel Formulas & Functions

[SOLVED] Total count of radios in for repair (challenge)

Started by israelalvarado‎, 03-01-2017 02:28 PM

5

566

Last Post By:: Last Post: 03-01-2017 05:56 PM; by israelalvarado

Forum:
Excel Formulas & Functions

[SOLVED] Summing Totals Based on Criteria

Started by robstark‎, 02-09-2017 03:02 PM

count, count and if, formula, sum and if

4

793

Last Post By:: Last Post: 02-10-2017 02:01 AM; by FDibbins

Forum:
Excel General

[SOLVED] Quantity Totals From Cells

Started by robstark‎, 02-09-2017 02:14 AM

3

550

Last Post By:: Last Post: 02-09-2017 03:02 PM; by JohnTopley

Forum:
Excel Formulas & Functions

Sum based on next column

Started by laalkgeorge‎, 08-17-2016 06:48 AM

3

753

Last Post By:: Last Post: 08-17-2016 01:31 PM; by southward

Forum:
Excel - New Users/Basics

[SOLVED] Which formula to use if value <1 then 1, and if value>1 then the result remains the same.

Started by thenewguyhere‎, 05-10-2016 02:52 AM

excel functions, formula and functions, formula and if statement, sum and if

9

770

Last Post By:: Last Post: 05-10-2016 03:22 AM; by thenewguyhere

Forum:
Excel Formulas & Functions

[SOLVED] Summing With Criteria

Started by lumos‎, 02-10-2016 12:13 PM

2

596

Last Post By:: Last Post: 02-10-2016 12:45 PM; by FDibbins

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.00 seconds.

Calculate YTD with criteria

Adding cells related to search criteria

Formula Not Displaying Negative Values Correctly

Sum data based on criteria regarding another cell

How to sum multiple cells in a referenced sheet without typing said sheet name again

Summing data based on one criteria that could be found in multiple columns

Performing a function on a range of cells if a certain condition is met

[SOLVED] Combing SUMIF SEARCH and XLookup

How to change cells based upon a another cell

[SOLVED] Sumif specific value in ayear

[SOLVED] Conditional Sum

[SOLVED] Count/Sum based on another column date range/value

[SOLVED] Sum Functions/formula: selection for addition base off of colours

[SOLVED] create sum out of a list based on activated options in 2 different lists

Summing values below cells that contain a specific text

Hello!! Joined this forum to get some help on excel

SUMIF calculation needed

Sum days/hours between multiple dates in excel with criteria

Sum of cells if 1 or more cells >0

[SOLVED] Estimated Quote value to be Zeroed where we have Net Sales figure in adjacent column

[SOLVED] sum, if column contains array of specific strings

Nesting a IF statement and Sum with refenced data that involves drop downs (pick list)

[SOLVED] Give a number a different value when summed

Distribution of values

Sum a range of values related to a range in a different column.

Count Min Max & Sum

[SOLVED] Multiple sumifs with variable conditions

Sum all above cells until you reach a blank cell

Create Sum based on IF statement formula?

[SOLVED] Total count of radios in for repair (challenge)

[SOLVED] Summing Totals Based on Criteria

[SOLVED] Quantity Totals From Cells

Sum based on next column

[SOLVED] Which formula to use if value <1 then 1, and if value>1 then the result remains the same.

[SOLVED] Summing With Criteria