getting a sum of cells in column (E) that have entries with value above zero.

[Max Mitchell]

I have column E showing elapsed time =($D$5-$C$5)*24. I want two totals from that column. One the total time elapsed and two the number of cells that have an entry as not all of them will. With the time formula, a simple sum function adds all of the columns.

[Pepe Le Mokko]

Total time =sum(e:e)
Cells with entry =counta(e:e)

[Max Mitchell]

Pepe, Thanks, i tried that but it totals all the cells. the empty cells have a 0.00 value.

[Pepe Le Mokko]

Then try=sumif(e:e,">0")