Is there an alternative to SUMIF for arrays?
|
|
14
|
608
|
December 21, 2023
|
COUNTIF/IFS with comparison operators for data referenced in a cell
|
|
2
|
300
|
May 4, 2023
|
Err 509 in sumif
|
|
3
|
13262
|
December 7, 2020
|
Sumif + groupby with dates
|
|
10
|
967
|
June 13, 2021
|
having trouble with sumifs
|
|
7
|
1097
|
May 14, 2021
|
Usage of MONTH in formula
|
|
9
|
1957
|
March 23, 2021
|
How to use the SUMIF() function when the array is horizontal
|
|
1
|
672
|
February 16, 2021
|
SUMIF for multiple sheets between 2 sheets
|
|
3
|
637
|
February 7, 2021
|
Can sumif take range value as a cell reference
|
|
3
|
532
|
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
|
346
|
August 20, 2020
|
OR inside SUMIF
|
|
4
|
857
|
July 31, 2020
|
Problem with SUMIF - maybe using dates
|
|
2
|
867
|
July 22, 2020
|
I need a way to detect if a field is a date in a sumif expression. Help?
|
|
2
|
436
|
June 20, 2020
|
Libreoffice Calc Sum of values depending of month and year of a range of dates
|
|
9
|
13410
|
July 31, 2021
|
SUMIF with different Criteria values?
|
|
6
|
2541
|
April 9, 2020
|
Calc: How to add flexible cell referenced "OR" conditions in SUMIFS?
|
|
5
|
531
|
March 10, 2020
|
Countif / Sumif greater than zero
|
|
3
|
2318
|
July 31, 2021
|
Calc - SUMIF based on cell background color
|
|
5
|
5091
|
May 30, 2019
|
Why is this SUMIF not working?
|
|
6
|
3549
|
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
|
2664
|
June 22, 2018
|
Calc: can you combine SUMIF and VLOOKUP?
|
|
1
|
4218
|
June 3, 2018
|
SUMIF on multiple cells if first cell ISBLANK?
|
|
3
|
905
|
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
|
1186
|
July 31, 2021
|
Add to total if there is data in another field?
|
|
3
|
347
|
July 31, 2021
|
Sum with two test ranges
|
|
4
|
389
|
July 31, 2021
|
SUMIF column of same row
|
|
2
|
716
|
July 31, 2021
|
Sum values in one column based on criteria in another
|
|
5
|
13734
|
July 31, 2021
|