Returning the sum of all values for multiple instances of a column search

**david.frame** · 10-05-2012, 12:12 PM

Sorry guys I bet that title was confusing. What I'm trying to do is search a column for all instances of a value. This is very difficult for me to explain in writing so I am attaching a sample spreadsheet.

What i need is to search a through a database of cables. each row entry has a "routing length" and a "cable type". I want to search for a particular "cable type" and sum up all of the "routing lengths" that have that type. I am doing it by hand right now by applying a filter to the "cable type", copying the filtered results into a separate table, and then summing the "routing lengths" column.

Is there any way I can do this with a formula?

**alansidman** · 10-05-2012, 12:24 PM

There is no attachment. But if I understand correctly, you should be able to do this using either SumIfs or SumIf formulae.

Look here for a short tutorial.

http://www.techonthenet.com/excel/formulas/sumif.php

**david.frame** · 10-05-2012, 12:28 PM

Sorry about that. I got distracted at work and forgot to upload the sample.

Thanks for the link i'll check that out!

**Econocrat** · 10-06-2012, 01:11 AM

It sounds like you want to use the countif function. For example, in AH2 I used the CountIf to find the instances of "BK-1 (BN)"

=COUNTIF(C1:C27,"BK-1 (BN)")

=7