Why does the returned value for Range 1 not match Criteria 1?
I am confused by the returned values for Range n in the SUMIFS function when using the Function Wizard or F9.
There appears to be an error in the example file on the SUMIFS function help page.
The sample
https://help.libreoffice.org/7.3/en-US/text/scalc/01/func_sumifs.html?DbPAR=CALC#bm_id658066580665806
Using the example file to illustrate my question.
NOTE: Function in cell G6 does not appear to match description in cell H7.
G6 =SUMIFS(C3:C30,B3:B30,“Model 02”,A3:A30,“City BB”)
H7 Sum all Model 01 cars in Show rooms in city BB
Why does Range 1 (B3:B30) return “Model 04” when Criteria 1 is “Model 02”?