subtotal - Search Results - Excel Help Forum

[SOLVED] Count number of entries with duplicates once in a filtered worksheet.

Started by avijit74‎, 08-13-2024 03:06 AM

duplicate once, offset, subtotal, sumproduct

20

438

Last Post By:: Last Post: 08-18-2024 05:39 AM; by AliGW

Forum:
Excel Formulas & Functions

Copy and Paste values of other sheets using SUBTOTAL based on conditional formatting value

Started by acsishere‎, 07-13-2024 05:05 PM

macro (vba), subtotal, subtotal conditional

1

157

Last Post By:: Last Post: 07-14-2024 03:46 AM; by JohnTopley

Forum:
Excel Programming / VBA / Macros

[SOLVED] auto count viseble cells with words

Started by MikalW‎, 09-29-2023 02:35 AM

7

554

Last Post By:: Last Post: 10-02-2023 09:22 AM; by JeteMc

Forum:
Excel Charting & Pivots

Wrong Subtotal in Pivot Table Distinct Count

Started by funxels‎, 05-11-2023 12:38 PM

2

1,551

Last Post By:: Last Post: 05-11-2023 12:52 PM; by alansidman

Forum:
Excel Charting & Pivots

Searching for MAX less than X via SUBTOTAL on filtered Data problem. Please Help!

Started by AmatuerNoob‎, 04-13-2023 11:40 PM

filtered data, less than, max, negative value, subtotal

1

414

Last Post By:: Last Post: 04-14-2023 04:13 AM; by XLent

Forum:
Excel Formulas & Functions

[SOLVED] MATCH function after SUBTOTAL (hidden rows count)

Started by LPAM‎, 02-22-2023 05:34 AM

3

523

Last Post By:: Last Post: 02-27-2023 09:19 AM; by JeteMc

Forum:
Excel - New Users/Basics

[SOLVED] Dynamic array formula to indicate which rows are visible and which are not

Started by Marbleking‎, 09-03-2022 07:15 AM

dynamic array, invisible rows, spill range, subtotal, visible rows

14

2,756

Last Post By:: Last Post: 09-03-2022 11:12 AM; by Fluff13

Forum:
Excel Formulas & Functions

Max Moving Average Formula REVISON

Started by Flyboy1969‎, 05-09-2022 02:11 AM

6

533

Last Post By:: Last Post: 05-10-2022 11:35 AM; by Flyboy1969

Forum:
Excel Formulas & Functions

VBA to find subtotal on Excel file opened on Teams sharepoint

Started by tanyann199‎, 03-15-2022 07:54 AM

1

299

Last Post By:: Last Post: 03-16-2022 08:53 AM; by Artik

Forum:
Excel Programming / VBA / Macros

Replacing OFFSET to sum up to max value from specific cell

Started by mfeengineer‎, 02-25-2022 01:59 PM

max, offset, offset alternative, subtotal, sum

8

865

Last Post By:: Last Post: 02-26-2022 09:58 PM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] Using Subtotal to calculate AVERGEIF, MAXIFS and MINIFS on filtered dataset

Started by SandraC‎, 01-19-2022 03:51 PM

3

408

Last Post By:: Last Post: 01-19-2022 04:33 PM; by Fluff13

Forum:
Excel Formulas & Functions

[SOLVED] Countif with filters, using sumproduct, subtotal and indirect

Started by Stephen Reeves‎, 11-16-2021 06:10 AM

countif with filters, indirect, subtotal, using sumproduct

4

604

Last Post By:: Last Post: 11-16-2021 08:12 AM; by TMS

Forum:
Excel Formulas & Functions

Excel Macro Find / Alter / Replace Function turn Subtotals into Sums

Started by DarthDiggler‎, 11-10-2021 02:21 PM

1

403

Last Post By:: Last Post: 11-11-2021 03:43 AM; by AlphaFrog

Forum:
Excel Programming / VBA / Macros

[SOLVED] Programming Hotkey for open ended formula

Started by blevinsj‎, 06-23-2021 11:38 AM

3

567

Last Post By:: Last Post: 06-23-2021 05:09 PM; by Aardigspook

Forum:
Excel - New Users/Basics

SUBTOTAL(?) count all fields including blanks in a filtered range

Started by joeyslaptop‎, 06-10-2021 03:10 PM

blanks, count blanks, counta blank cells, filtered range, subtotal

3

2,263

Last Post By:: Last Post: 03-31-2023 07:39 AM; by meharbanpal

Forum:
Excel Formulas & Functions

[SOLVED] SUMIF Function for cells that will be filtered (SUBTOTAL)

Started by newmaldener‎, 05-25-2021 08:36 AM

6

552

Last Post By:: Last Post: 05-26-2021 12:07 PM; by Fluff13

Forum:
Excel Formulas & Functions

Getting =COUNTIFS to change when results are filtered - Please help!

Started by Mattmcging‎, 04-26-2021 09:43 AM

countif, countifs, filter, subfunction, subtotal

4

632

Last Post By:: Last Post: 04-27-2021 06:03 AM; by bebo021999

Forum:
Excel Formulas & Functions

[SOLVED] Get Total of Specific Background Colored Cells Pt. 2

Started by jimjones1958‎, 04-19-2021 04:50 PM

12

995

Last Post By:: Last Post: 04-23-2021 01:51 AM; by jimjones1958

Forum:
Excel Programming / VBA / Macros

Need for a pivot table in the subtotal row the sum of column with averages.

Started by MarcBergmans‎, 03-31-2021 03:26 PM

1

599

Last Post By:: Last Post: 04-01-2021 05:27 AM; by rorya

Forum:
Excel Charting & Pivots

Subtotal only group duplicates if value in column

Started by Chickenbones‎, 02-18-2021 09:30 PM

5

758

Last Post By:: Last Post: 02-19-2021 11:28 AM; by jindon

Forum:
Excel Programming / VBA / Macros

I need to count nonblank values in a filtered list by two criteria. Please help!

Started by Jarvis_Cain‎, 01-25-2021 02:57 PM

filtered range, multiple criteria, subtotal, subtotal if, sumproduct

5

799

Last Post By:: Last Post: 01-31-2021 01:46 PM; by JeteMc

Forum:
Excel Formulas & Functions

[SOLVED] AverageIF within a subtotal

Started by ChrisNaughton‎, 01-20-2021 09:19 AM

3

670

Last Post By:: Last Post: 01-20-2021 10:13 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Using COUNTIFS across numerous columns within a SUBTOTAL

Started by ChrisNaughton‎, 01-15-2021 12:01 PM

7

634

Last Post By:: Last Post: 01-15-2021 01:20 PM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

Adding levels to Pivot table Subtotal

Started by EsbenFjer‎, 01-09-2021 08:12 AM

2

667

Last Post By:: Last Post: 01-13-2021 09:17 PM; by hansolu

Forum:
Excel Charting & Pivots

(Sub)Total for Columns in Pivot Table

Started by MandEQueen‎, 10-23-2020 01:51 PM

1

723

Last Post By:: Last Post: 10-26-2020 08:55 PM; by JeteMc

Forum:
Excel Charting & Pivots

[SOLVED] Getting a vertical array containing the maximum values from each row of a 2D matrix

Started by Marbleking‎, 08-14-2020 02:41 PM

10

654

Last Post By:: Last Post: 08-15-2020 12:19 PM; by Bo_Ry

Forum:
Excel Formulas & Functions

[SOLVED] Dynamic array will not pass through to the 'TotalList' parameter in my subtotal routine

Started by James McEwan‎, 07-22-2020 11:33 AM

array, for ... each loops, subtotal, vba

3

537

Last Post By:: Last Post: 07-22-2020 12:29 PM; by CK76

Forum:
Excel Programming / VBA / Macros

[SOLVED] Count visible autofilter results

Started by Mr_Phil‎, 07-20-2020 06:58 PM

4

591

Last Post By:: Last Post: 07-21-2020 10:49 PM; by GeoffW283

Forum:
Excel Formulas & Functions

[SOLVED] Detect content in hidden columns

Started by Barren_Wuffett‎, 06-11-2020 01:25 PM

5

707

Last Post By:: Last Post: 06-11-2020 03:09 PM; by CK76

Forum:
Excel Formulas & Functions

Subtotal Question (stock spreadsheet)

Started by Irish15‎, 04-01-2020 07:56 PM

charts, excel, spreadsheets, stocks, subtotal

5

882

Last Post By:: Last Post: 04-01-2020 10:55 PM; by Irish15

Forum:
Excel General

[SOLVED] How to use countif with subtotal

Started by lewini‎, 01-24-2020 05:01 AM

4

1,335

Last Post By:: Last Post: 01-28-2020 12:07 PM; by lewini

Forum:
Excel Formulas & Functions

Sumproduct Isnumber Search is returning same result for different values

Started by labruzzi‎, 11-06-2019 03:44 PM

isnumber, multiple criteria, search, subtotal, sumproduct

1

924

Last Post By:: Last Post: 11-07-2019 12:36 AM; by NARAYANK991

Forum:
Excel Formulas & Functions

Average ifs for filtered data

Started by Mikes_KM‎, 06-16-2019 06:14 AM

averageifs, filter, hidden cells, subtotal, trading

16

2,825

Last Post By:: Last Post: 06-22-2019 09:44 PM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

[SOLVED] Sub Total Data based on Criteria

Started by penbeacho‎, 12-17-2018 10:02 PM

3

733

Last Post By:: Last Post: 12-19-2018 11:56 AM; by Alf

Forum:
Excel Programming / VBA / Macros

Running Total: Not Sure Which Function to Use

Started by thesuperman97‎, 12-12-2018 08:00 PM

1

608

Last Post By:: Last Post: 12-12-2018 08:09 PM; by Pete_UK

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Count number of entries with duplicates once in a filtered worksheet.

Copy and Paste values of other sheets using SUBTOTAL based on conditional formatting value

[SOLVED] auto count viseble cells with words

Wrong Subtotal in Pivot Table Distinct Count

Searching for MAX less than X via SUBTOTAL on filtered Data problem. Please Help!

[SOLVED] MATCH function after SUBTOTAL (hidden rows count)

[SOLVED] Dynamic array formula to indicate which rows are visible and which are not

Max Moving Average Formula REVISON

VBA to find subtotal on Excel file opened on Teams sharepoint

Replacing OFFSET to sum up to max value from specific cell

[SOLVED] Using Subtotal to calculate AVERGEIF, MAXIFS and MINIFS on filtered dataset

[SOLVED] Countif with filters, using sumproduct, subtotal and indirect

Excel Macro Find / Alter / Replace Function turn Subtotals into Sums

[SOLVED] Programming Hotkey for open ended formula

SUBTOTAL(?) count all fields including blanks in a filtered range

[SOLVED] SUMIF Function for cells that will be filtered (SUBTOTAL)

Getting =COUNTIFS to change when results are filtered - Please help!

[SOLVED] Get Total of Specific Background Colored Cells Pt. 2

Need for a pivot table in the subtotal row the sum of column with averages.

Subtotal only group duplicates if value in column

I need to count nonblank values in a filtered list by two criteria. Please help!

[SOLVED] AverageIF within a subtotal

[SOLVED] Using COUNTIFS across numerous columns within a SUBTOTAL

Adding levels to Pivot table Subtotal

(Sub)Total for Columns in Pivot Table

[SOLVED] Getting a vertical array containing the maximum values from each row of a 2D matrix

[SOLVED] Dynamic array will not pass through to the 'TotalList' parameter in my subtotal routine

[SOLVED] Count visible autofilter results

[SOLVED] Detect content in hidden columns

Subtotal Question (stock spreadsheet)

[SOLVED] How to use countif with subtotal

Sumproduct Isnumber Search is returning same result for different values

Average ifs for filtered data

[SOLVED] Sub Total Data based on Criteria

Running Total: Not Sure Which Function to Use