Counting with blank cells

[chrisdavies71]

Hi everyone,

I have a formula like this in cell E14:

=IF(COUNT(C14:D14)=2,(D14-C14)*24,"")

which is checking that there are numbers in both cells, if yes find the difference, if no leave blank.

This formula repeats a number of times along a row with different cells referenced.

At the end of the row I need to be able to add up the total of those referenced cells eg E14, H14, K14 but I get a #VALUE ! error.

What am I doing wrong?

Regards

Chris

 

[Fluff]

Difficult to tell, without knowing what formula your using.
How about
=SUM(E14,H14,K14)