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=540468

In column C put

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

- it doesn't give unique entries but shows against any 'space' row the
total for that name. Did you need unique?

--

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...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540468

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...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540468