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
|