Sum cells if meets criteria

Highlighted
Occasional Visitor

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 Replies
Highlighted

Hi @Moo2002  

 

You can try constructing your formula as below 

 

 

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

 

 

2020-09-23_00-21-07.png

 

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

Highlighted

@Moo2002 

Not practical, just in case

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