•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does SUMIFS ask for "criteria range, criteria" while FILTER asks for "criteria range = criteria"?
I'm curious this morning why some functions, e.g. SUMIF(S), ask for criteria ranges and criteria in separate parameters, i.e. criteria range, criteria while others like FILTER or SUMPRODUCT ask for them both in the same parameter, i.e. criteria range = criteria. They both make sense, I'm just confused as to why they aren't consistent.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#SUMIFS
#SUMIF
#Excel
#criteria range
#criteria
#FILTER
#SUMPRODUCT
#separate parameters
#functions
#criteria ranges
#parameters
#same parameter
#formulas
#confused
#syntax