Count if or Sum Product

[Brandy]

I apologize if this is a duplicate submission.

I have a spreadsheet of data with two columns of data for which I need to
summarize on another spreadsheet. Column A lists makes/models and Column B
counts the number sold. The original spreadsheet will contain multiple
duplicate entries of the same makes/models for which I need to summarize.

Ex:
Column A Column B
7444 loader 2


Which formula would be best for this project?

Thank you!

 

[JLatham]

SUMIF() is probably what you want. You can either set up several cells with
all possible combination of makes/models to give you results, or you could
set up a single cell to enter a make/model pairing. Lets say you set up a
cell like that in C1, then in D1 you could have a formula similar to
=SUMIF(A1:A100,"=" & C1,B1:B100)

If you go with the individual make/model pairings to see all combinations,
then each formula would look something like:
=SUMIF(A1:A100,"=7444 loader",B1:B100)

 

[Brandy]

That worked! Thank you so much. Now, if I wanted to add another column
(with text) to drill the information down even more, would I add another
search criteria to the formula? Sorry for all the questions, but I just
can't get it together today.

Thanks!

 

[JLatham]

Hard to say without knowing what you've done so far (which of my possible
solutions did you use), and what is it you now need to do to drill down
further?

 

[Brandy]

I used the second formula. This is the info I am trying to drill down
(summarize)

Column A Column B Column C
7444 loader 2 Market Segment

My original spreadsheet contains multiple duplicate entries for which I am
trying to summarize.

Thanks again for your help.

 

[JLatham]

It may be a matter of switching to a SUMPRODUCT() formula at this point, or
of revising the formula to reference the entries in your column C. I'm just
not certain of what you're actually shooting for as a result in the end.

It may be easier to work directly together via email from this point on.
Feel free to contact me at (remove spaces)
Help From @ jlatham site. com

It would help if you could send a sample workbook along with an explanation
of what you're working toward as an attachment to the email, if you send one.

 

[Brandy]

Thank you so much-I have emailed you an example of the report I am working.

 

[JLatham]

And I've returned it with what i hope is a solution that'll work for you and
that you can modify for further use in the project.

ALL: I was correct, at this point we had to move to a SUMPRODUCT() formula
to get counts based on multiple criteria. SUMIFS() would also work in Excel
2007 for the solution.