Formula so there isnt a 0 when u have yet to fill in certain

[dondondon]

hello....my quest in becoming an expert excel user has moved to the next level with every bit of help i get from u guys.

heres the problem...i have a list of names with a few columns of wins and losses after. then at the end, i have total wins and total loses. the wins and loses are for cetain days so i have multiple colums of them. when they are empty, the fill my excel chart with 0s till no end! Or, when just the first one is filled, i get even negative numbers! is there a way i can make an IF statement or anything else for the matter so i dont get anything in final cell until all the fields previous to them are filled? thanks again

[Juan Pablo González]

Not sure what you want, but try with this:

=IF(AND(LEN($B$2:B2)),"Calculate","")

Where your "expected" data starts in B2. Then, drag across (or down).

Replace the "Calculate" with your real calculation.

[stone]

Try to use IF and ISBLANK functions togather.

I dont quite understand your description.

Stulli