Yes, there is a criteria that will identify the non-blank cells in the sum_range column. You can use the
operator in the criteria argument of the
function to sum the non-blank cells. Here's how you can modify the formula:
- Formula:
Formula:
=SUMIF(A$8:A20,"<",B$8:B20)
- This formula will sum all the cells in the range that have a corresponding non-blank cell in the range.
- The operator means "not equal to". So, the criteria argument will match all cells that are not blank.