G
Guest
Hello,
I have a spreadsheet that contains averages and sums of columns, tracking
mileage and fuel costs by the month for 12 months. The first 3 months (12
separate Sheets) obviously have data in them: Jan ~ March, but the rest of
the sheets display [#DIV/0!] where data has yet to be entered.
I know it is something simple but I just can’t remember how to return
nothing in the cells where data isn’t present.
YTD sheet #13, cell I57 = Apr-06 I70 which contains this function [=AVERAGE
(I61:I69)]
I am thinking it is something like this but haven’t gotten it right so far:
[ =AVERAGE (I61:I69) IF<0=0 ]
I want the cells to display 0 or nothing if data has not yet been entered.
Thanks so much for your help!
I have a spreadsheet that contains averages and sums of columns, tracking
mileage and fuel costs by the month for 12 months. The first 3 months (12
separate Sheets) obviously have data in them: Jan ~ March, but the rest of
the sheets display [#DIV/0!] where data has yet to be entered.
I know it is something simple but I just can’t remember how to return
nothing in the cells where data isn’t present.
YTD sheet #13, cell I57 = Apr-06 I70 which contains this function [=AVERAGE
(I61:I69)]
I am thinking it is something like this but haven’t gotten it right so far:
[ =AVERAGE (I61:I69) IF<0=0 ]
I want the cells to display 0 or nothing if data has not yet been entered.
Thanks so much for your help!