=SUMPRODUCT(--(A1:A100="nov"),--(B1:B100=6.4))

--
Gary''s Student - gsnu200755


"Jock" wrote:

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