All,

I am having some trouble with a count formula in my worksheet.
Example:

I have Cell1-10 in col A populated with the name 'john'
Col B contains different numerical values for Cell 1-10, three of them
being the number 5.

Is there a formula I can use that will give me a count of any cells in
Col A with the value 'John' *AND* any cells in col B with the value
'5'

Help would be much appreciated.

Jason B


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile: http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484058

Hi!

Try this:

=SUMPRODUCT(--(A1:A10="John"),--(B1:B10=5))

Better:

C1 = John
D1 = 5

=SUMPRODUCT(--(A1:A10=C1),--(B1:B10=D1))

Biff

"nosaj_enryb"
wrote in message
...

All,

I am having some trouble with a count formula in my worksheet.
Example:

I have Cell1-10 in col A populated with the name 'john'
Col B contains different numerical values for Cell 1-10, three of them
being the number 5.

Is there a formula I can use that will give me a count of any cells in
Col A with the value 'John' *AND* any cells in col B with the value
'5'

Help would be much appreciated.

Jason B


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile:
http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484058

=SUMPRODUCT(--(A1:A10="John"),--(B1:B10=5))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nosaj_enryb"
wrote in message
...

All,

I am having some trouble with a count formula in my worksheet.
Example:

I have Cell1-10 in col A populated with the name 'john'
Col B contains different numerical values for Cell 1-10, three of them
being the number 5.

Is there a formula I can use that will give me a count of any cells in
Col A with the value 'John' *AND* any cells in col B with the value
'5'

Help would be much appreciated.

Jason B


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile:
http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484058

Perfect. Works a charm. Many thanks guys


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile: http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484058