COUNTIF & AND

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
=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)
 
=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
 
superb gentlemen, Thanks to all
--
Traa Dy Liooar

Jock


Bob Phillips said:
=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)
Click to expand...
 
Back
Top