GrassHopper
New Member
- Joined
- Oct 17, 2002
- Messages
- 9
I am trying to come up with a sum of certain cells in a row based on what is in the column.
Each row is a detail of hours, each column is a classification of those hours ie
columns REG OT OT1 OT2 LL
detail 1 .5 0 0 .25
what I want is sum of detail if columns = OT OT1 OT2.
I am able to create a simple sum of the cells that correspond with the appropriate columns, however if another column is added, then my total has the possibility of adding up the wrong cells.
I have tried a sumif, ie
=SUMIF(A2:A6,"OT""OT1""OT2",B2:B6)
but I end up with a 0 total
your help is much appreciated
Each row is a detail of hours, each column is a classification of those hours ie
columns REG OT OT1 OT2 LL
detail 1 .5 0 0 .25
what I want is sum of detail if columns = OT OT1 OT2.
I am able to create a simple sum of the cells that correspond with the appropriate columns, however if another column is added, then my total has the possibility of adding up the wrong cells.
I have tried a sumif, ie
=SUMIF(A2:A6,"OT""OT1""OT2",B2:B6)
but I end up with a 0 total
your help is much appreciated