=sumproduct(--(A1:A100<B1:B100)

perhaps?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Keep It Simple Stupid" wrote
in message ...
Each account number should be scheduled a various number of times per
week.
Column A = Account Number;
Column B = Times/wk they SHOULD be scheduled

Each row represents a scheduled service, i.e. if they are ACTUALLY
scheduled
2x per week, there should be two rows.
Driver numbers are also in the other columns as well.

How can I quickly identify services that are not scheduled for the
appropriate number of services, i.e. the number of rows for each
particular
account is not equal to Column B?