Hi Guys I'm a little stumped and I need some help. I have three columns (Column A -OPTION YR, Column B - Purchase Order, Column C - PO CLOSED). For this particular spreadsheet I need to uniquely identify Purchase Orders were CLOSED in OPTION YR 2. But I have Purchase Orders that have the same number and do not need them counted twice.......anyone know how to get the value based on the sumproduct formula??? Below the answer I'm trying to get is 3
OPTION YR PURCHASE ORDER PO CLOSED
2 N589 Y
2 N589 Y
2 N456 Y
2 N093 Y
1 T123 Y
1 T145 Y
1 T156 Y
5 M834 Y
OPTION YR PURCHASE ORDER PO CLOSED
2 N589 Y
2 N589 Y
2 N456 Y
2 N093 Y
1 T123 Y
1 T145 Y
1 T156 Y
5 M834 Y