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.
--
Ann Scharpf