Displaying Totals on another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=SUMPRODUCT(--(names_range="name"),--(reasons_range<>""))

--

HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add/Subtract columns from tab to tab in same file 3
Using VBA to copy data into another worksheet ??? 2
Referring to "previous" worksheet 8
Adding totals of cells depending on contents of another cell 2
Combining Two Worksheets Of Data. 3
How to have a drop down selection list 2
How to count/summarize multiple Criteria - URGENT ASSISTANCE NEEDEDPLEASE!!!!! 2

Back
Top