I have different sales offices in sheet1 column E E2 thru E8

I have revision numbers in sheet1 column I I2 thru I8

Data as follows

E2=NF I2=emptycell

E3=DP I3=40619

E4=DP I4=emptycell

E5=NU I5=emptycell

E6=DP I6=40609

E7=DP I7=emptycell

E8=SF I8=40618

Sheet2 column A are my offices

A2=DP

A3=NU

A4=SF

A5=NF

In sheet2 column c I need excel to enter a number to indicate how many times an office gets a revision number. Correct answers for above example should be DP=2 NU=0 SF=1 NF=0. But I cannot seem to get the formula right. I keep getting #NUM or # VALUE and so on. Would appreciate any help thank you.

Todd

## Bookmarks