I'm trying to figure out in what way I can sum up the currency values of
select cells in a row based upon alternate select cells having a value that
is not blank.  I'm trying to create a worksheet that will allow our group to
order items and provide totals.  So, if they do not enter anything into that
particular column the adjacent one will stay blank.  However, if they enter a
quantity in column a then column b will provide a total.  I've gotten that
far.  What I want to do now is to read those specific quantity columns and if
they have a number (isnumber) then to add those values.  For instance, I
typed in the formula: SUM(IF(ISNUMBER(D7,F7,I7,L7)),d7:L7) and in various
arrangements of this sort I either receive text of the formula in the cell,
get an error in the formula comment, or it just remains blank even if one of
the criteria is not.  If I use only one cell value for 'isnumber' then the
formula works fine, but I need to be able to list specific discontinuous
cells and that's where I get into trouble.  I've tried replacing the commas
with a space and 'or' in between, but that doesn't seem to work.  I'm still
new to all of this so maybe the answer is obvious, but I just can't seem to
find it.  Thank you for any help you can offer.