Calculation on a non-blank cell in a horizontal range

[JSchell]

Hi,

Been knocking my head against this for too long. I have this spreadsheet where I am trying to add a formula in column D to search for a value in a row of cells from F-Q (columns don't matter).

So essentially, I want the formula to find the value in the row (there will only be one value or blank) and then do a calculation on that value.

For example: Search row 5 to see that there is a value in H5 then do a calculation on the value of $1600.00.

I figured it was an IF statement coupled with ISBLANK, but that doesn't seem to work as everything I have seen looks for a specific value as opposed to the value that is in the cell that isn't blank.

• The values will all be numeric.
• There will only be one value per row.
• The value could be virtually any amount.

Thanks in advance for the help!

 

[Fluff]

Are there formulae in those cells that return "" or are they totally empty?

 

[Scott Huish]

Just do a SUM on that row.
=SUM(F5:Q5)

 

[JSchell]

Hi,

They are totally empty and the dollar values that are there are inputted manually.

 

[JSchell]

Just do a SUM on that row.
=SUM(F5:Q5)

Thanks, I can't believe it was that easy, I was looking for a more complex method apparently.