Sum cells if meets criteria

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

Hi @Moo2002  


You can try constructing your formula as below 








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


Not practical, just in case