IF function advise

this may not line up right.. but hopefully you can get the idea... all those '0's need to be BLANK UNLESS there is a number greater than 0 for the row, does that make sense? YOU ARE A LIFE SAVER
PAY PAY TOTAL SAT SUN MON TUE WED THUR FRI
CODE TYPE HOURS
WORKED REGULAR 0
WORKED REGULAR 40 8 8 8 8 8
WORKED REGULAR 0
WORKED REGULAR 0
WORKED REGULAR 0
WORKED REGULAR 0
WORKED REGULAR 0
REGULAR 0
OVERTIME 0
OVERTIME 0
OVERTIME 0
OVERTIME 0
OVERTIME 0
OVERTIME 0
OVERTIME 0
VACATION 0
SICK 0
HOLIDAY 0
COMP 0

Assuming the summing field for each row is from column 4 to column 100

- assuming your first row of calculation is in row B
- for the 1st row
=if(sum($B4:$B100)<=0,"",sum($B4:$B100))

fill down

Thanks alot... that formula worked leaving out the $ signs... don't know what they were suppose to do but it didn't work with them there so I try taken them out and it worked.
Time sheets had to be done today so you were a life saver... THANKS so much for your help...

Forums like these are life-savers for us that know enough to make us dangerous....

AGAIN, THANKS .
Kathy Fakes