•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