Explanation
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:
COUNTIF(C6:E6,">=5")=3
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:
SUM(C6:E6)>=15)
If both the the logical conditions return TRUE, the AND function will return TRUE. IF either returns FALSE, AND will return false.
Related functions
AND Function
The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF...
COUNTIF Function
The Excel COUNTIF function returns the count of cells in a range that meet a single condition. The generic syntax is COUNTIF(range, criteria), where "range" contains the cells to count, and "criteria" is a condition that must be true for a cell to be counted. COUNTIF can be used to count cells...
SUM Function
The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.
