I cannot post the workbook or data due to security issues.
Am trying to do something to this effect:
IF X = "A" OR X = "N" THEN A
ELSEIF X = "B" OR "N" THEN B
Basically, I want "N" to count in both groups I am creating.
So far it is not working at all.
Cant do it in groups the way you have written it but try sets - then you can combine the sets
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.