#value formula result

[Will Rose]

I'm trying to add together 5 cells where the content of the cells is the following formula:

Cell Q7 formula =IFERROR((P7*O7),"")

using the following formula: =SUM(Q7+U7+Y7+AC7+AG7)

However, until i put a value in cells P7 & O7 (and the corresponding cells for the other 4 cells i'm trying to sum) and the formula calculates and gives a value to the cells, the for all of the 5 cells with this formula the i just getting "#value" in the sum column.

Is there a way round this?

 

[etaf]

you are using iferror - so that should solve the error

add that to the sum()

did you only want to calculat when the 5 cells are not blank

if(COUNTA(Q7,U7,Y7,AC7,AG7)=5, SUM(Q7+U7+Y7+AC7+AG7), "")

 

[Fluff]

Replace the + signs in the sum with commas.

 

[Will Rose]

Replace the + signs in the sum with commas.

Fluff, you're a star. Thank you. Knew there would be a simple answer.

 

[Fluff]

Glad we could help & thanks for the feedback.