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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum a row, but just the cells, where there is a number.
Are you trying to count the number of cells that have numbers in them or are
you tyring to sum that row? (your title vs what is in the message is a bit unclear.) Try, COUNTIF If you are trying to count the number of cells that have numbers. "??RUTH??" wrote: 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 |
Reply |
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 |