Excel - COUNTIFS with multiple criteria and OR logic
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.