Sum if one criteria over multiple cells

[Bkisley]

Hey everyone!

I have a data set that I would like to summarize - and no I can not use a data table or pivot chart for what I am doing.

I have 4 types of cost classifications - Internal Engineering, Internal Testing, External Engineering, and External Testing

I need to have an equation that does the following....
if the cell value in column D (or replace the rows to the right with a D instead of a G) between D8:D78 equals Internal Engineering grab the sum of cells G8, G13, G18, G23, G28, G33, G38, G43, G48, G53, G58, G63, G68, G73, G78.

I need the same if the value is the other three classifications as well.

Basically I just need to sum up anything in column G that has a value equal to each of the 4 classifications below.

Please let me know if I need more explanation

 

[Eric W]

Glad to hear it!