Summing up rows that only have all the values

[Rob]

Can you help please, I need a formula to add up the values in a row, but only
if the row has a complete set of values
e.g for a row containing the following values I would expect the following
answers

20 22 20 25 21 = 108
19 20 21 20 = "blank"

 

[Jacob Skaria]

Use the IF condition

=IF(COUNT(A1:E1)=5,SUM(A1:E1),"Blank")

If this post helps click Yes

 

[Jacob Skaria]

Revised one...You dont need to specify the no of columns

=IF(COUNT(A16:E16)=COLUMNS(A16:E16),SUM(A16:E16),"Blank")

If this post helps click Yes

 

[Rob]

Worked a treat thank you

Revised one...You dont need to specify the no of columns

=IF(COUNT(A16:E16)=COLUMNS(A16:E16),SUM(A16:E16),"Blank")

If this post helps click Yes