Summing up rows that only have all the values
 

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"

Summing up rows that only have all the values
 

Use the IF condition

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

If this post helps click Yes
---------------
Jacob Skaria


"Rob" wrote:

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"

Summing up rows that only have all the values
 

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
---------------
Jacob Skaria


"Rob" wrote:

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"

Summing up rows that only have all the values
 

Worked a treat thank you

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Rob" wrote:

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"