Re: Help Counting

Giganews Newsgroups
Subject: Re: Help Counting
Posted by:  Bryan Hessey (Bryan.Hessey.27ke5m_1147218902.7219@excelforum-nospam.com)
Date: Tue, 9 May 2006

Drag down column C the formula

=IF(COUNTIF(A$1:A1,A1)<=1,SUMPRODUCT((A$1:A$20=A1)*(B$1:B$20="space")),"")

--

Brento Wrote:
> 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

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread:http://www.excelforum.com/showthread.php?threadid=540468

Replies

None

In response to

Help Counting posted by Brento on Tue, 9 May 2006