The result will be TRUE or FALSE.

The second requirement is to have at least 15 volunteer hours in total.

As long as the sum is at least 15, this expression will return TRUE.

Excel AND function

Finally the results from the two expressions above are evaluated by the AND function.

If both the logical expressions return TRUE, the AND function will return TRUE.

If either expression returns FALSE, AND will return FALSE.

Excel COUNTIF function

AND returns TRUEonly if all the conditions are met.

If any conditions are not met, the AND function returns FALSE.

These values can be numbers, cell references, ranges, arrays, and constants, in any combination.

Excel SUM function

SUM can handle up to 255 individual arguments.