Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Substract holidays of number of days in the current month 2
- Fabian76
April 13, 2020 at 4:19 AM
- Fabian76
April 17, 2020 at 9:50 PM
-
- Replies
- 2
- Views
- 804
2
-
-
-
-
Subtract a set value from a cell on a specific day and replace cell value 2
- ExcelDumDum
March 15, 2016 at 3:45 PM
- ExcelDumDum
March 15, 2016 at 4:29 PM
-
- Replies
- 2
- Views
- 1.2k
2
-
-
-
-
Subtracting time depending on text in a previous cell 13
- CaulfieldS
January 17, 2017 at 4:50 PM
- CaulfieldS
January 17, 2017 at 6:01 PM
-
- Replies
- 13
- Views
- 1.9k
13
-
-
-
-
Subtraction With Catagories 1
- jgaffney86
August 18, 2022 at 6:57 PM
- jgaffney86
August 21, 2022 at 4:25 AM
-
- Replies
- 1
- Views
- 397
1
-
-
-
-
Sum a value if its Date is within 90 days of each Month shown in second table 6
- burdenpi
August 7, 2017 at 4:10 AM
- burdenpi
August 7, 2017 at 8:05 PM
-
- Replies
- 6
- Views
- 859
6
-
-
-
-
Sum across variable columns for a specific store 6
- IvanYerk
January 29, 2020 at 12:57 PM
- IvanYerk
February 20, 2020 at 1:41 PM
-
- Replies
- 6
- Views
- 1.2k
6
-
-
-
-
Sum across worksheets while ignoring hidden worksheets 13
- mike_calc
January 26, 2021 at 4:02 PM
- mike_calc
January 27, 2021 at 2:28 PM
-
- Replies
- 13
- Views
- 1.6k
13
-
-
-
-
Sum against multiple sheets 6
- mitank
July 3, 2018 at 10:06 AM
- mitank
July 4, 2018 at 3:09 PM
-
- Replies
- 6
- Views
- 1.1k
6
-
-
-
-
sum all months of the year 1
- Maysara
December 25, 2022 at 3:30 PM
- Maysara
December 25, 2022 at 6:02 PM
-
- Replies
- 1
- Views
- 368
1
-
-
-
-
Sum Area Based on Compound Row and Column Criteria 13
- DC Mega
January 14, 2018 at 12:47 PM
- DC Mega
September 18, 2018 at 6:59 AM
-
- Replies
- 13
- Views
- 2.4k
13
-
-
-
-
Sum average networkdays if cells aren't empty
- Sp0ns
January 17, 2018 at 2:12 PM
- Sp0ns
January 17, 2018 at 2:12 PM
-
- Replies
- 0
- Views
- 254
-
-
-
-
sum based on 2 row criteria values.
- reggieneo
January 20, 2018 at 8:23 AM
- reggieneo
January 20, 2018 at 8:23 AM
-
- Replies
- 0
- Views
- 257
-
-
-
-
Sum based on three criteria, using two named ranges 4
- GlassGal
May 31, 2017 at 7:41 PM
- GlassGal
May 31, 2017 at 9:33 PM
-
- Replies
- 4
- Views
- 670
4
-
-
-
-
SUM but only the last instance / occurrence if there are duplicates
- James324
March 12, 2018 at 3:35 PM
- James324
March 12, 2018 at 3:35 PM
-
- Replies
- 0
- Views
- 211
-
-
-
-
Sum cell numerical values based on text suffix 3
- QAM
September 27, 2018 at 4:16 PM
- QAM
September 28, 2018 at 11:16 AM
-
- Replies
- 3
- Views
- 589
3
-
-
-
-
sum cells in an excel column that fall between cells that fit a specific criteria? 20
- Laura Garnham
September 26, 2018 at 3:19 PM
- Laura Garnham
October 9, 2018 at 8:36 AM
-
- Replies
- 20
- Views
- 1.8k
20
-
-
-
-
sum cells only if adjacent cell has value 1
- Fleur
July 27, 2017 at 1:18 PM
- Fleur
August 13, 2017 at 9:05 AM
-
- Replies
- 1
- Views
- 539
1
-
-
-
-
Sum columns based on mutiple criteria 1
- shani75
December 20, 2016 at 1:19 PM
- shani75
December 20, 2016 at 1:22 PM
-
- Replies
- 1
- Views
- 727
1
-
-
-
-
Sum each cell skipping columns 4
- onexc
September 22, 2023 at 7:16 PM
- onexc
September 24, 2023 at 8:48 AM
-
- Replies
- 4
- Views
- 386
4
-
-
-
-
Sum extra hours worked before today and subtract leave hours based on text string 2
- creativespace
February 23, 2017 at 12:47 PM
- creativespace
February 23, 2017 at 7:53 PM
-
- Replies
- 2
- Views
- 752
2
-