Sum cells if meets criteria

[Moo2002]

I want to add a range of cells (B3:K3) if cell L3 is >=.8.  If L3 is <.8, then I want the result to return as blank.  Thanks to anyone who can help.

[#2]

Hi @Moo2002  

You can try constructing your formula as below 

=IF(SUM(B3:K3)>=8,SUM(B3:K3),"")

Also attached the sample file for your ready reference

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

[#3]

@Moo2002 

Not practical, just in case

=XLOOKUP(SUM(B3:K3),8,SUM(B3:K3),"",-1)