Yes, there is a criteria that will identify the non-blank cells in the sum_range column. You can use the

Formula:

"<" 


operator in the criteria argument of the

Formula:

SUMIF 


function to sum the non-blank cells. Here's how you can modify the formula:

1. Formula:
   Formula:

   =SUMIF(A$8:A20,"<",B$8:B20) 

2. This formula will sum all the cells in the
   Formula:

   B$8:B20 

   range that have a corresponding non-blank cell in the
   Formula:

   A$8:A20 

   range.
3. The
   Formula:

   "<" 

   operator means "not equal to". So, the criteria argument
   Formula:

   "<" 

   will match all cells that are not blank.