Excel - COUNTIFS with multiple criteria and OR logic

IF statement to add/deduct points from average

When you use multiple criteria with OR logic, caution is required so that you don't double-count. In some situations it can be easy to accidentally double count by applying criteria that are too loose. I'd suggest doing a double check on a couple of rows (or columns) of data to verify accuracy.

свернуть