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.

All you have to do is list the cells within the Sum() function.

=Sum(D7,F7,I7,L7)

If any of those particular cells is either empty, contain text, or a formula
that returns a 0 or a null ( "" ), it will still calculate the correct
total.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"stumped" wrote in message
...
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.

Thank you for your help. I was trying to make it too difficult. I also
wanted the 'total' column to remain blank if the sum was zero and so just
reversed the formula to an IF nested with a sum function which now works
perfectly. Thanks again.

"RagDyeR" wrote:

All you have to do is list the cells within the Sum() function.

=Sum(D7,F7,I7,L7)

If any of those particular cells is either empty, contain text, or a formula
that returns a 0 or a null ( "" ), it will still calculate the correct
total.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"stumped" wrote in message
...
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.

You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"stumped" wrote in message
...
Thank you for your help. I was trying to make it too difficult. I also
wanted the 'total' column to remain blank if the sum was zero and so just
reversed the formula to an IF nested with a sum function which now works
perfectly. Thanks again.

"RagDyeR" wrote:

All you have to do is list the cells within the Sum() function.

=Sum(D7,F7,I7,L7)

If any of those particular cells is either empty, contain text, or a
formula
that returns a 0 or a null ( "" ), it will still calculate the correct
total.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"stumped" wrote in message
...
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.