Excel 2007 : Help with IF or LOOKUP function

[Not You]

I'm not sure quite how to do this.

I have a column (Column A) of items that are selected from a drop down list.

Here are the options from that list. Math, Science, English, Art

I want to write a formula that says, If column A = Math, then enter the adjacent total number of students from Column B.

In column B, these totals would be user entered based on the option selected in column A.

So I want to know what the total number of students in Math (Column A) from column B and then add the total of those and put it in another cell. So it would look up every time Math appears in column A, then it would look at the adjacent cell in column B to find the number associated with it, and then it would add those numbers up and give a total.

TIA.

[FDibbins]

A sample file with what you have and what you want would make it easier to help you?

[Not You]

Here you go, thanks.

I should add that I'm not looking to do a simple SUM calculation, I want Excel to find every time it says "Math" in column A, and add the number of students adjacent to it in column B for a running total.

[DBY]

Hello
The SUMIf function in cell D9 copied across to G9 should give you the results you're looking for.

=SUMIF($A$3:$A$24,D$8,$B$3:$B$24)

Hope this helps.

[Not You]

I stand corrected that is a very simple IF function and works great, thank you.