Help Counting

HI,

It is probably an easy one but my mind is blank. I need help with this formula.

I have names in column A and either a number or a word in column B the word is 'space'

What i need the formula to say is count all the 'space' enteries against each name.

so if jon appeared 10 times in the list and space apeared 4 time alongside his name the result would be 4. Th names in column a are jumbled please help

thanx

=SUMPRODUCT(--(A2:A100="jon"),--(B2:B100="space"))

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Brento" <Brento.27k9an_1147212602.6912@excelforum-nospam.com> wrote in
message news:Brento.27k9an_1147212602.6912@excelforum-nospam.com...
>
> HI,
>
> It is probably an easy one but my mind is blank. I need help with this
> formula.
>
> I have names in column A and either a number or a word in column B the
> word is 'space'
>
> What i need the formula to say is count all the 'space' enteries
> against each name.
>
> so if jon appeared 10 times in the list and space apeared 4 time
> alongside his name the result would be 4. Th names in column a are
> jumbled please help
>
> thanx
>
>
> --
> Brento
> ------------------------------------------------------------------------
> Brento's Profile:
> http://www.excelforum.com/member.php...o&userid=25213
> View this thread: http://www.excelforum.com/showthread...hreadid=540469
>