There are two requirements that must be satisfied, and both evaluated inside a single AND statement. The first requirement is at least 5 volunteer hours in each of the 3 categories: A, B, and C. This requirement is tested with a logical statement based on the COUNTIF function:
In the range C6:E6, we count numbers greater than or equal to 5.
The second requirement is to have at least 15 volunteer hours total. This requirement is tested with a simple logical expression based on the SUM function:
If both the the logical conditions return TRUE, the AND function will return TRUE. IF either returns FALSE, AND will return false.