Combining date criteria and logical test

Combining date criteria and logical test



I got three columns: 'date' 'paid' and 'price'. In the 'paid' column I
fill in 'cash', 'bank' or 'not'.

Now I want the sum of the 'price' column, in another cell, based on the
next criteria's:

 - it must be in one particular month (MONTH('date')=1 gives me the
results for januari)
but I want to combine it with;
 - 'paid' column must not be 'not' (or must be 'cash' and 'bank')

How can I get this done? The SUMIFS() function doesn't let me use MONTH()
and it's not possible to =SUM(IF(AND(MONTH()...

Any genious maths or excel person that can help me out?