Libre Office 18.104.22.168 English
Mac OS X 10.9.5 English
Popup Definition: SUMIF(range,criteria,sum_range)
purpose: two columns of expense values (e.g. cash in col B, check in col C)
and several columns of expense type with value 1 if expense is that type (food col D, restaurant col E, misc col F)
so if a 1 in the food type column D, then include any value in column B and column C of that row into the total sum.
Only the values in the first column of the sum_range will be added.
Is this a defect or is “sum_range” actually "sum_ROWrange?