To find the number of orders with A/P terms less than 25 months, what Excel formula should be used in A12?
A) =COUNTIF(F4:F10,"

Question

To find the number of orders with A/P terms less than 25 months, what Excel formula should be used in A12?
A) =COUNTIF(F4:F10,"<25")
B) =COUNT(F4:F10,25)
C) =AVERAGE(F4:F10,"<25")
D) =COUNTIF(F4:F10,F5)

Quizplus · Accepted Answer

The COUNTIF function can be used to count the number of orders with A/P terms less than 25 months. The range to be counted is F4:F10, and the criteria is "<25", which specifies that only values less than 25 should be counted. Therefore, the correct formula is =COUNTIF(F4:F10,"<25").

To Find the Number of Orders with A/P Terms Less