Count formula Help...

[nosaj_enryb]

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

 

[Biff]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

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

--

HTH

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


"nosaj_enryb" <[email protected]>
wrote in message
news:[email protected]...

 

[nosaj_enryb]

Perfect. Works a charm. Many thanks guy