superb gentlemen, Thanks to all
--
Traa Dy Liooar

Jock


"Bob Phillips" wrote:

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

I am assuming that the code is a number, if it is a text field, use "6.4"
etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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