IF function advise

[katintn]

I have a time sheet spread with multiple rows that return zero alot of the time but the zero's create a visual problem when reading, I'd like to have the cell return nothing if there is not a sum for the week, is this possible. I have did the IF function but only get the blank field and don't know how to have it return the sum IF there are totals in the row?

THANKS in advance
Kathy

[lazyme]

I think this is what you want?
=IF(SUMIF(Range,Criteria)>0,SUMIF(Range, Criteria),"")

However, sometimes having a 0 value is useful when you need to work with the number later on. In that case, you can always set a conditional formula that turns all 0 to a white font.

[katintn]

Okay... I know what the 'range' is but then the ,criteria confuses me... what do I put there in each case?
sorry to sound so clueless...
Kathy

[lazyme]

the SUMIF function has 2 part:

Range - the range of cells that you want to evaluate

Criteria - is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", "apples".

If you still want more explaination, feel free to post your worksheet and I will help you out.

[katintn]

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

[lazyme]

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

[katintn]

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