Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum value of nonblank discontinuous cells
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding only NONBLANK cells | Excel Discussion (Misc queries) | |||
SumIf with discontinuous cells? | Excel Discussion (Misc queries) | |||
Allow pasting as a value to several discontinuous cells at once. | Excel Discussion (Misc queries) | |||
Can an array be made of discontinuous cells of the same row? | Excel Discussion (Misc queries) | |||
counting nonblank cells | Excel Worksheet Functions |