Summing cells from a column if an adjacent column contains a specified value

[jpotts89]

I'm looking for some help with an issue I'm having in excel. I am looking to generate a sheet that summarizes data that I export from a health website on a daily basis.

In Column A, I have multiple values representing a meal or time of day (i.e. breakfast, afternoon, midnight, etc.) and in Column's D through J are cells I want to sum. Every row of data is an individual food item I consumed that day, so that means column A can contain multiple "breakfasts" or any time label for that matter.

With additional rows of exported data existing below the "Meals" section of the export, with cells that contain data, I want to generate a formula that allows me to sum an entire column, given that the the adjacent cell in Column A contains one of eight specified labels that are only used for the "Meals" section of the report (mentioned above).

I've been playing with Sumifs, Vlookups, and match to generate a formula, but I haven't been able to get it to work yet. I am hoping that some one knows how to get this to work.

[NBVC]

Do you mean?

In B4, for Calories:

=SUM(INDEX('11.29'!E:E,MATCH("Meal",'11.29'!A:A,0),0):INDEX('11.29'!E:E,MATCH("Fitness",'11.29'!A:A,0)-1,0))

copied down and adjust the '11.29'!E:E ranges to '11.29'!F:F for sugars, etc...

[jpotts89]

Thanks NBVC! I wasn't aware of the Index function and it looks like something that is very helpful to know.