Adding together a range of values but omiting certain values

Hi everyone,

This is my first post here as I need a hand with a formula for work and I majorly struggle with formulas if I don't have an example to work from.

The problem I have is that I'm trying to add a range of values together for a cell in a table, although I want excel to select the values to add based on the value of the cell next to it.

For instance,

I want to add up the value of deals won in November and I want this to appear in table A on a different tab.
In table B on the original tab I have one column for the date and one for the value.
The problem is that I want it to omit any values in the range that don't have November in the date column.

And I can't get past that.

Any help would be much appreciated! Thanks.

Try this.

=SUMPRODUCT(--(Month(A2:A100) = 11), B2:B100)

Thank you so much, that works like a dream!