Adding cells containing/related to certain text

**JackieChrist** · 06-27-2012, 09:09 AM

In the spreadsheet attached, I'm trying to get a total of all the specific types of systems shipped throughout a year. These totals should go in the red-background boxes at the top. For instance, the total for System AAA should be 3. The total for System BBB should be 6, etc.

I'm not sure how to tell Excel to add up the numbers from all the different customers only pertaining to the AAA Type of System. Could someone explain how to do so, and perhaps give me a function that will perform my desired action?

Thanks!

**jeffreybrown** · 06-27-2012, 09:22 AM

Hello & Welcome to the Forum,

Try this in E5 copied down

=SUMPRODUCT(--($N$24:$Y$30=D5),$N$26:$Y$32)

**JackieChrist** · 06-27-2012, 09:27 AM

That worked great! Thanks! Would you mind explaining what that code means though? I'm trying to learn to do this sort of thing by myself.

**jeffreybrown** · 06-27-2012, 09:29 AM

You are very welcome and thanks for the feedback

This site explains it far better than I could

EDIT: Now that I think about it, this would be more efficient. =SUMIF($N$24:$Y$30,D5,$N$26:$Y$32)

I had Sumproduct on the brain at the moment

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save