Office & documentsHow to fix the Excel SUMIFS #VALUE! error when criteria ranges differ in size
When SUMIFS returns a #VALUE! error, first check that all ranges in the formula have the same number of rows and columns, as Microsoft Support explains for sum_range and criteria_range.










