Is there an alternative to SUMIF for arrays?
|
|
14
|
1300
|
December 21, 2023
|
COUNTIF/IFS with comparison operators for data referenced in a cell
|
|
2
|
397
|
May 4, 2023
|
Err 509 in sumif
|
|
3
|
14255
|
December 7, 2020
|
Sumif + groupby with dates
|
|
10
|
1156
|
June 13, 2021
|
having trouble with sumifs
|
|
7
|
1284
|
May 14, 2021
|
Usage of MONTH in formula
|
|
9
|
2282
|
March 23, 2021
|
How to use the SUMIF() function when the array is horizontal
|
|
1
|
835
|
February 16, 2021
|
SUMIF for multiple sheets between 2 sheets
|
|
3
|
778
|
February 7, 2021
|
Can sumif take range value as a cell reference
|
|
3
|
702
|
January 6, 2021
|
I need to sum certain ranges based on the condition of individual cells not being blank.
|
|
4
|
654
|
December 15, 2020
|
Sumif displays no results out cell reference
|
|
1
|
427
|
August 20, 2020
|
OR inside SUMIF
|
|
4
|
1052
|
July 31, 2020
|
Problem with SUMIF - maybe using dates
|
|
2
|
1012
|
July 22, 2020
|
I need a way to detect if a field is a date in a sumif expression. Help?
|
|
2
|
503
|
June 20, 2020
|
Libreoffice Calc Sum of values depending of month and year of a range of dates
|
|
9
|
14118
|
July 31, 2021
|
SUMIF with different Criteria values?
|
|
6
|
2836
|
April 9, 2020
|
Calc: How to add flexible cell referenced "OR" conditions in SUMIFS?
|
|
5
|
636
|
March 10, 2020
|
Countif / Sumif greater than zero
|
|
3
|
2504
|
July 31, 2021
|
Calc - SUMIF based on cell background color
|
|
5
|
5450
|
May 30, 2019
|
Why is this SUMIF not working?
|
|
6
|
3781
|
February 9, 2019
|
Comparative test: linked workbooks fail to transition from Excel/Windows to Calc/Linux pt2
|
|
0
|
366
|
November 23, 2018
|
Sumif using multiple partial matches
|
|
4
|
2929
|
June 22, 2018
|
Calc: can you combine SUMIF and VLOOKUP?
|
|
1
|
4363
|
June 3, 2018
|
SUMIF on multiple cells if first cell ISBLANK?
|
|
3
|
1018
|
July 31, 2021
|
If row contains the correct month then add amount in row B to total. Otherwise don't
|
|
4
|
547
|
July 31, 2021
|
Multisheet column reference doesn't work for SUMIF or SUMPRODUCT
|
|
2
|
1386
|
July 31, 2021
|
Add to total if there is data in another field?
|
|
3
|
405
|
July 31, 2021
|
Sum with two test ranges
|
|
4
|
472
|
July 31, 2021
|
SUMIF column of same row
|
|
2
|
793
|
July 31, 2021
|
Sum values in one column based on criteria in another
|
|
5
|
14417
|
July 31, 2021
|