I have a worksheet that contains roughly 3000 rows of data for inventory.  

In column A is the list of names .  Most names are listed more than once
because people order more than one product. I used COUNTIF to get my totals
on another worksheet for total of orders per person.

In another column are the reasons the order can't be filled which is about
12 different reasons.

What I am trying to do is get a total by their name of their orders that
can't be filled listed on a seperate worksheet so I can chart it.  I don't
need the specific reasons just a number.