Sum values in column Y if the values in column X are the same

[Maikevr]

I'm working on a nutritional project and I want to determine the average KiloJoule intake per week out of a large food intake survey. Therefore, I want to sum the values of K for each person entry (column A). For example, I want to sum I for rows 2:5 as these are the different ingredients that one unique person ate. I sum these values in column Q, so I can eventually calculate the average KiloJoule intake per meal. This is way to much work to do manually, how can I compute the sum of values of K separately for all unique person entries in column A?

Thanks in advance!

[/URL][/IMG]

 

[AlanY]

try the =sumif(), sumifs() functions

 

[Maikevr]

try the =sumif(), sumifs() functions

I've tried that, but in that case I would still have to manually get each value of column Q right?

 

[AlanY]

you shouldn't if you use Col A (id) as your criteria for the sumif()

eg, to get the answer of 1956 in Q163,

=SUMIF(A:A,A9,K:K)

 

[AlanY]

or you can tidy them up with this in Q2, and copy down

=IF(AND(A2<>A1,A2=A3),SUMIF(A:A,A2,K:K),"")

 

[Maikevr]

you shouldn't if you use Col A (id) as your criteria for the sumif()

eg, to get the answer of 1956 in Q163,

=SUMIF(A:A,A9,K:K)

Thank you, I see that that works, but the point is that I want to get all of my Q values simultaneously instead of computing each one individually. I expect that column to get more than 100 entries.

 

[AlanY]

Thank you, I see that that works, but the point is that I want to get all of my Q values simultaneously instead of computing each one individually. I expect that column to get more than 100 entries.

have to tried the suggestion in post#5?

 

[Maikevr]

have to tried the suggestion in post#5?

Yes, that did not work unfortunately

 

[AlanY]

Yes, that did not work unfortunately

care to elaborate?