G'day,
I am having a little trouble working this out if it is even possible. what i have is a sheet with say 10-50 rows of data. What i would like to do is this. I want it to match certain criteria in one column and then take the value of that in another column and add all the same criteria together.
With the below example(the picture at the bottom in the link), what i would like to do is to match all the values that are the same in column f for example 4642 (there are 4 rows that are 4642) and then take the value from column c and add them all together and put the sum of them in the box down the bottom(row 37 column d) and the answer would be 108.
Thank you in advance for any help that comes from this. It's greatly appreciated.
I am having a little trouble working this out if it is even possible. what i have is a sheet with say 10-50 rows of data. What i would like to do is this. I want it to match certain criteria in one column and then take the value of that in another column and add all the same criteria together.
With the below example(the picture at the bottom in the link), what i would like to do is to match all the values that are the same in column f for example 4642 (there are 4 rows that are 4642) and then take the value from column c and add them all together and put the sum of them in the box down the bottom(row 37 column d) and the answer would be 108.
Thank you in advance for any help that comes from this. It's greatly appreciated.
