Good morning all and thank you for taking the time to read my post.

I’m new to excel and trying to create a document with some values in of my monthly electricity bill (boring I know lol).

To simplify, I have 3 cells. Let’s call them A1, B1 and C1. These cells contain a value as I input data each month. So, row 1 would be Jan, 2 February etc.  up to December. D1 would be my result.

I want to Add together A1+B1+C1 and put that into D1. If however I have no data I want blank “” in D1.

The issue I have is the months I have no data for yet returns #value. I want it to read blank until I input data but I don’t want to copy the formula each time, I want the formula to always stay in the sheet.

I have managed to create a formula for returning blank if I Have 1 cell blank =IF(A1=””,””,A1+B1+C1), but I can’t see how to look at 3 cells for blank. I have tried multiple methods like =IF(A1,B1,C1=””,””,A1+B1+C1) etc but get error messages or #value returned in D1

I hope this makes sense and thank you again.

​Good morning all and thank you for taking the time to read my post. I’m new to excel and trying to create a document with some values in of my monthly electricity bill (boring I know lol). To simplify, I have 3 cells. Let’s call them A1, B1 and C1. These cells contain a value as I input data each month. So, row 1 would be Jan, 2 February etc.  up to December. D1 would be my result. I want to Add together A1+B1+C1 and put that into D1. If however I have no data I want blank “” in D1. The issue I have is the months I have no data for yet returns #value. I want it to read blank until I input data but I don’t want to copy the formula each time, I want the formula to always stay in the sheet. I have managed to create a formula for returning blank if I Have 1 cell blank =IF(A1=””,””,A1+B1+C1), but I can’t see how to look at 3 cells for blank. I have tried multiple methods like =IF(A1,B1,C1=””,””,A1+B1+C1) etc but get error messages or #value returned in D1 I hope this makes sense and thank you again.  Read More

​