COUNTIF & AND
 

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

COUNTIF & AND
 

=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

COUNTIF & AND
 

=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

COUNTIF & AND
 

=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

COUNTIF & AND
 

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