Is there an alternative to SUMIF for arrays?
|
|
14
|
614
|
December 21, 2023
|
COUNTIF/IFS with comparison operators for data referenced in a cell
|
|
2
|
301
|
May 4, 2023
|
Err 509 in sumif
|
|
3
|
13279
|
December 7, 2020
|
Sumif + groupby with dates
|
|
10
|
973
|
June 13, 2021
|
having trouble with sumifs
|
|
7
|
1099
|
May 14, 2021
|
Usage of MONTH in formula
|
|
9
|
1963
|
March 23, 2021
|
How to use the SUMIF() function when the array is horizontal
|
|
1
|
674
|
February 16, 2021
|
SUMIF for multiple sheets between 2 sheets
|
|
3
|
638
|
February 7, 2021
|
Can sumif take range value as a cell reference
|
|
3
|
534
|
January 6, 2021
|
I need to sum certain ranges based on the condition of individual cells not being blank.
|
|
4
|
521
|
December 15, 2020
|
Sumif displays no results out cell reference
|
|
1
|
347
|
August 20, 2020
|
OR inside SUMIF
|
|
4
|
859
|
July 31, 2020
|
Problem with SUMIF - maybe using dates
|
|
2
|
869
|
July 22, 2020
|
I need a way to detect if a field is a date in a sumif expression. Help?
|
|
2
|
437
|
June 20, 2020
|
Libreoffice Calc Sum of values depending of month and year of a range of dates
|
|
9
|
13421
|
July 31, 2021
|
SUMIF with different Criteria values?
|
|
6
|
2544
|
April 9, 2020
|
Calc: How to add flexible cell referenced "OR" conditions in SUMIFS?
|
|
5
|
533
|
March 10, 2020
|
Countif / Sumif greater than zero
|
|
3
|
2321
|
July 31, 2021
|
Calc - SUMIF based on cell background color
|
|
5
|
5096
|
May 30, 2019
|
Why is this SUMIF not working?
|
|
6
|
3554
|
February 9, 2019
|
Comparative test: linked workbooks fail to transition from Excel/Windows to Calc/Linux pt2
|
|
0
|
275
|
November 23, 2018
|
Sumif using multiple partial matches
|
|
4
|
2667
|
June 22, 2018
|
Calc: can you combine SUMIF and VLOOKUP?
|
|
1
|
4220
|
June 3, 2018
|
SUMIF on multiple cells if first cell ISBLANK?
|
|
3
|
908
|
July 31, 2021
|
If row contains the correct month then add amount in row B to total. Otherwise don't
|
|
4
|
463
|
July 31, 2021
|
Multisheet column reference doesn't work for SUMIF or SUMPRODUCT
|
|
2
|
1192
|
July 31, 2021
|
Add to total if there is data in another field?
|
|
3
|
349
|
July 31, 2021
|
Sum with two test ranges
|
|
4
|
391
|
July 31, 2021
|
SUMIF column of same row
|
|
2
|
716
|
July 31, 2021
|
Sum values in one column based on criteria in another
|
|
5
|
13746
|
July 31, 2021
|