| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum a row, but just the cells, where there is a number.
hi,
I want to calculate numbers in a row, but just, when there is a number in the cell. if there is no number, don't count. I tried: =IF(H26:N26=1,((H26:N26-H9:N9)*H6:N6),"") Problem: the cells, which are blank or rather 0 are not missed out. thx for every help. ruth |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
