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
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