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]
Thanks in advance!
![nl.tinypic.com](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fnl.tinypic.com%3Fref%3D2hzr71k%22%5D%5BIMG%5Dhttp%3A%2F%2Fi63.tinypic.com%2F2hzr71k.png&hash=5e85cf7792ebfb03c4f80f471abc9992)