Hi.

I am creating a workbook for work.

The main part I am having trouble with is finding a formula that will sum, when two specific words are entered in two separate fields.

For Example...

Column A has a drop down list, with these options: A, B, C, D
Column B has a drop down list, with these options: 1, 2, 3, 4

What i want to do is create a table like this:

A B C D

1
2
3
4

So when column A has option A selected, and column B has option 1 selected, i want it to count in the table.

I want to be able to enter possible combination's multiple times as i go down the workbook, and i would like the table to continue to add up on a separate workbook. Ive tried countif and sumproduct but if i enter the same combination more that once it adds up incorrectly.

I hope this makes sense

Thanks