yogi_Prepare A CrossTab Of Number Of New And Used Cars Sold By Different Salesmen

                                          Google Spreadsheet   Post  #959

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 07, 2013

user Eraldo Genovese said:(http://productforums.google.com/forum/?zx=6xwd73m1l93e#!category-topic/docs/spreadsheets/38QCCG3ltZI)
Which Function shall I use ?
Hello everybody I would like to figure out which function to use  to count how many contract of used car each salesman did.

here it is the sheet

https://docs.google.com/spreadsheet/ccc?key=0AiSqxjl65vsedHZGbWJ0TDhKQ2FlN1RjYzFSYW9Lc1E#gid=4

thank you so much in advance for your help

Eraldo

--------------------------------------------------------------------------------------------

following is a single array formula solution