Sum if criteria is a name

G

Guest

Hi all..Sorry if this question was sent before by error.

Here is my question.

I have two sheets with datas like this, but I have one sheet where I have
only the name of the person, what I want is this:

Put a criteria in the Sheet#1 where it sum all Invoice values of second
sheet if the name is X ,
Example:

Sheet#1
Salesperson InvoiceTotal
Buchanan 29000
Suyame 28000

Sheet#2
Salesperson Invoice
Buchanan 15000
Buchanan 9000
Suyama 8000
Suyama 20000
Buchanan 5000
Dodsworth 22500

anybody can help me with this,,I'll appreciate so much.

Note: Pivot Table or Query does not work according what I want,

Thanks.
ldiaz
 
G

Guest

=SUMIF(Sheet2!$A$2:$A$7,A2,Sheet2!$B$2:$B$7)

I don't understand, when I was looking for the answer in the help I found
this as an example. What is the problem you are experiencing?
 

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

repeating names in row fields of a pivot table 1
Help with a formula (Multiple lines to sum and return if) 2
Subtotal function with an If criteria 3
Extract Headers from Crosstab query 2
Counting number of cells that make up a sum.. 2
Excel 2002 - Pivot Table : Can I divide instead of sum ? 1
Sum range of a week if condition is equal to.. 3
Sum cells using criteria from a row and a column 2

Top