Reply to thread

Message: [QUOTE="Ann Scharpf, post: 3860305"] I have a bunch of columns with dollar values. I want to add the sum of all the values for rows that meet a single condition. If possible, I'd like to create a named a range that includes all the non-contiguous dollar value columns and use a single SUMIF(). In my test, I named this range DOLLARS. The formula =SUM(DOLLARS) does work fine and adds up ALL the values. To test the SUMIF(), I set up a column (named range "decision") with yes/no values. I get a #VALUE error when I try the formula =SUMIF(decision,"=yes",dollars). I looked at some of the posts for array functions and I can't really tell if an array formula would fix this problem. Is this possible to do as a single function, or do I have to have something like this: =SUMIF(decision,"=yes",dollars1)+SUMIF(decision,"=yes",dollars2)... Thanks for your help. [/QUOTE]