It would have been a lot easier if you had told us that earlier.
I assume that where you say "once I input data in B3, B4 etc.." you may have
intended to say "once I input data in Sheet1!A2 , Sheet1!A3 etc.." ?

Simple to cure. Change your =Sheet1!A2 to =IF(Sheet1!A2="","",Sheet1!A2)
and copy down.
--
David Biddulph

"K-Man" wrote in message
...
....
The problem is that my calculations in blank cells which have no data
in it defaults to zero so when I referece those cells when doing my
calculation it gives me zero, anything multiplied by 0 is 0 I guess..

Here's my worksheet:
B2
=sheet1!A1 (which is 94)
B3
=Sheet1!A2 (which is blank, data to be entered in future)
B4
=Sheet1!A3 (which is blank, data to be entered in future)
B5
=Sheet1!A4 (which is blank, data to be entered in future)
B6
=product(B2:B5) (it willgive you blank or zero depending if you have
the checkmark set to options view tab)

The answer I am looking for is 94, for B6 however it will update once
I input data in B3, B4 etc..it should not give me zero or blank.

....