Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas
I have created a spreadshhet and in one column I can enter data and the
"total" is automatically populated as an AVERAGE for the week's stats. It works fine when I input the data. But when it is left blank (e.g. the column for Thursday 14, for which I have no data yet) the following text appears in the Average cell: "#DIV/0!" (without the quotation marks). Can I hide or delete this so that it looks blank until data is entered without removing the formula? Thank you, Rob, Teesside, UK |
#2
|
|||
|
|||
Hi Abfabrob
You did not post your formula, but I think you are using a straightforward formula. Just after the "=" in this cell's formula, insert the words IF(<address of your empty cell here="","", - now go right to the end of the formula and insertt a closing bracket ")" there Regards "abfabrob" wrote: I have created a spreadshhet and in one column I can enter data and the "total" is automatically populated as an AVERAGE for the week's stats. It works fine when I input the data. But when it is left blank (e.g. the column for Thursday 14, for which I have no data yet) the following text appears in the Average cell: "#DIV/0!" (without the quotation marks). Can I hide or delete this so that it looks blank until data is entered without removing the formula? Thank you, Rob, Teesside, UK |
#3
|
|||
|
|||
Hi,
Thanks for this. But I can't get it to work! My formula is (literally): =AVERAGE(D4:D8) What should it literally look like with your suggestion? Thanks again, Rob "Kassie" wrote: Hi Abfabrob You did not post your formula, but I think you are using a straightforward formula. Just after the "=" in this cell's formula, insert the words IF(<address of your empty cell here="","", - now go right to the end of the formula and insertt a closing bracket ")" there Regards "abfabrob" wrote: I have created a spreadshhet and in one column I can enter data and the "total" is automatically populated as an AVERAGE for the week's stats. It works fine when I input the data. But when it is left blank (e.g. the column for Thursday 14, for which I have no data yet) the following text appears in the Average cell: "#DIV/0!" (without the quotation marks). Can I hide or delete this so that it looks blank until data is entered without removing the formula? Thank you, Rob, Teesside, UK |
#4
|
|||
|
|||
"abfabrob" wrote in message
... Hi, Thanks for this. But I can't get it to work! My formula is (literally): =AVERAGE(D4:D8) Try =IF(COUNTA(D4:D8)=0,"",AVERAGE(D4:D8)) HTH, Andy |
#5
|
|||
|
|||
I bet you meant to count numbers:
=IF(COUNT(D4:D8)=0,"",AVERAGE(D4:D8)) (Just in case there's text in those cells.) Andy Brown wrote: "abfabrob" wrote in message ... Hi, Thanks for this. But I can't get it to work! My formula is (literally): =AVERAGE(D4:D8) Try =IF(COUNTA(D4:D8)=0,"",AVERAGE(D4:D8)) HTH, Andy -- Dave Peterson |
#6
|
|||
|
|||
Andy,
Thank you so much, it worked perfectly! Cheers, Rob, Teesside, UK "Andy Brown" wrote: "abfabrob" wrote in message ... Hi, Thanks for this. But I can't get it to work! My formula is (literally): =AVERAGE(D4:D8) Try =IF(COUNTA(D4:D8)=0,"",AVERAGE(D4:D8)) HTH, Andy |
#7
|
|||
|
|||
Andy,
Thank you so much, it worked perfectly! Cheers, Rob, Teesside, UK "Andy Brown" wrote: "abfabrob" wrote in message ... Hi, Thanks for this. But I can't get it to work! My formula is (literally): =AVERAGE(D4:D8) Try =IF(COUNTA(D4:D8)=0,"",AVERAGE(D4:D8)) HTH, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |