if statement help

  • Thread starter Thread starter romeo1mike
  • Start date Start date
R

romeo1mike

I need help with a formula that will do the following. I have a list o
names in b2:b10. Those names are in no order and are duplicated. I hav
sales as they relate to the name in a2:a10. I need to count each name
total sales. So if the name steve is in b2:b10 4 times and his sale
are in a2:a10 as 10,20,30,40 then the answer would be 100. Thanks fo
the hel
 
Hi

=SUMIF(B2:B10,"John",A2:A10)
etc. for every name

Or enter the unique list of names into a column, and in every formula refer
to cell it this list (and set reference style to absolute for both condition
and sum ranges in formula). P.e.
=SUMIF(B$2:B$10,X2,A$2:A$10)
and copy formula down - unique names are in column X, starting from X2

Or create a pivot table (Data.PivotTable... from menu, and follow
instructions) based on your data.
 
Thank Frank, is it possible to add another criteria like location t
that... so in the end it would be B2:B10, "Steve" and C2:C10 "Spai
then sum, A2:A10.... Is that possible to have to criteria to mee
before adding up the sales??? Thanks again
 
=SUMPRODUCT(--(B2:B10="Steve"),--(C2:C10="Spain"),A2:A10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top