Sum from criteria over multiple ranges

[ljw220]

Hello-

I have a spreadsheet that is being used to keep track of demographic information for a daily survey of a public space. There are many columns which contain a single letter, each of which indicates a particular trait of a single park user (race, age, gender, dress, etc). Here is a quick example of what I'm looking at:

clip.jpg

What I would like to do with this is create a formula that looks at criteria from multiple cell ranges and creates a sum if all of these conditions are met, for more advanced demographic tallies that will occur over the course of the year. For example, if my age column = "A" and my race column = "W" and my gender column = "M", I know that equates to one adult white male....so, if I can tell the software to look to see if these three things are true, I can set up a counter for that particular group. Is there a way to write a sumif formula (or other function) that will accomplish this?

Thanks in advance.

[Ace_XL]

Use SUMIFS on these lines

=SUMIFS(Sum_Column,Age_Column,"A",Race_Column,"W",Gender_Column,"M")