In my March 9 post<\/a> I brought up sumif(), pointing out that it will selectively add values within a given range.<\/p>\n sumif() offers one more level of flexibility: you can use a different test range from the sum range.<\/p>\n Example: Consider the following partial spreadsheet:<\/strong><\/p>\n <\/p>\n Let’s imagine that, above, 110 is in the A1 position.<\/p>\n The sumif() formula can be used with the following format:<\/p>\n =sumif(decision_range,condition,range_to_add)<\/p>\n Note that, in this case, the first parameter is the range to check for agreement with the condition<\/span>, while the range of numbers to potentially add is the final parameter.<\/p>\n Continuing with the example, let’s imagine that the formula<\/p>\n =sumif(b1:b5,”red”,a1:a5)<\/p>\n is entered in cell c6. It will add only the cells adjacent to the value “red”, and return the value 90.<\/p>\n =sumif(decision_range,condition,range_to_add)<\/p>\n seems to work the same with Excel or LibreOffice Calc:)<\/p>\n\n
\n A<\/td>\n B<\/td>\n<\/tr>\n \n 110<\/td>\n green<\/td>\n<\/tr>\n \n 40<\/td>\n red<\/td>\n<\/tr>\n \n 50<\/td>\n red<\/td>\n<\/tr>\n \n 90<\/td>\n green<\/td>\n<\/tr>\n \n 70<\/td>\n green<\/td>\n<\/tr>\n<\/table>\n