How to count the number of filled rows in EXCEL according to a criterion?

P

partyzanx2019-03-08 20:01:40

excel

partyzanx, 2019-03-08 20:01:40

File https://yadi.sk/i/n-WMHhqOf_XVXw
The second question will be how to calculate separately the number of adult cards, adult guests, children cards and children of guests from the following table? Guests have "Guest" in "AK code", and cardholders, respectively, do not have this "guest" parameter.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Kiselyov, 2019-03-10
@partyzanx

=COUNTIF(F:F,"VZR")
Instead of column F, of course, you can specify a direct range of the form F12:F100.
Second question
= COUNTIFS