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.

"Brandy" wrote:

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


"JLatham" wrote:

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" wrote:

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" wrote:

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" wrote:

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!

"Brandy" wrote:

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!