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