formula help

[jim may]

In Range A1:E2 I have values

1.89 1.99 2.09 3.40 2.25
1.90 2.10 1.90

I need in Cell F2 a formula to produce the figure -0.33 (1.90-1.89+2.1-2.09+1.90-2.25)
The 2nd row minus the first row, but only include or consider the columns that have a value
on the 2nd row

Any thoughts?

TIA,

 

[jim may]

PGC - You are the absolute man!!
Thanks greatly,
Jim

I was using the If() + If() + If() + (210 characters)

 

[pgc01]

I'm glad it helped.

Cheers