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.

--
Very Thankful

=SUMPRODUCT(--(names_range="name"),--(reasons_range<>""))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joey041" <(E-Mail Removed)> wrote in message
news:8A57A439-08A3-46A3-AF34-(E-Mail Removed)...
> 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.
>
> --
> Very Thankful