View Single Post
  #1   Report Post  
Anthony
 
Posts: n/a
Default Formula help please

Hi,
Can you help?

in Worksheet 'Stats' cell H8 I want the value of cell R8 in worksheet 'Log'
to be shown, but if the value in cell R8 in worksheet 'Log' is zero (0), then
I want the cell H8 in 'Stats' to be blank.

Just to complicate things (if it does), there is already a formula in cell
R8 of the 'Log' worksheet, which is
=COUNTIF(Log!$A$3:A34852,"1")

Go easy as I'm the novice
Cheers for help