Hi guys,
Please refer to the attached workbook for reference. I need to create a countifs function with an OR component, but can't figure out how. Its probably a sum(countifs(or array function or something like that.
I would like to count:
Id = 1, 2, 3, 4 (the total number of times this ID appears. For this function I reference a cell is another list such as B4=1, B5=2, etc...), and
BW = (1)PY1, and
CH = (2)Not terminated, and
FJ = (2)Not terminated, and
DJ OR GL = (1)Yes
For example: The correct number for ID 1 should be 3 because ID one appears three times with BW=(1)PY1, CH=(2)Not terminated, FJ(2)Not terminated, and although DJ are no's it turned into three yes's in GL. I hope that makes sense
Its the last part, the DJ or GL that is messing me up. This is a partial list for reference purposes only, and not the full list.
Bookmarks