=SUMPRODUCT(--(A2:A50="Nov"),--(B2:B50=6.4))



or if you have real dates in A

=SUMPRODUCT(--(ISNUMBER(A2:A50)),--(MONTH(A2:A50)=11),--(B2:B50=6.4))


--


Regards,


Peo Sjoblom


"Jock" wrote in message
...
If I have the month displayed in column A and code numbers in column B,
how
can I combine the above so it adds up the instances that Nov is in column
A
AND 6.4 (code) is in column B

Thanks,

--
Traa Dy Liooar

Jock