Volunteer hours requirement calculation

Volunteer hours requirement calculation

Generic formula 

=AND(COUNTIF(rng,">=5")=3,SUM(rng)>=15)

Explanation

This examples shows how to calculate a volunteer hour requirement. The requirement is to have 15 volunteer hours, with at least 5 in each category. The formula in F6 is:

=AND(COUNTIF(C6:E6,">=5")=3,SUM(C6:E6)>=15)

How this formula works

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.

Volunteer hours requirement calculation

Generic formula 

=AND(COUNTIF(rng,">=5")=3,SUM(rng)>=15)

Explanation

This examples shows how to calculate a volunteer hour requirement. The requirement is to have 15 volunteer hours, with at least 5 in each category. The formula in F6 is:

=AND(COUNTIF(C6:E6,">=5")=3,SUM(C6:E6)>=15)

How this formula works

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.