Help Counting

[Brento]

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]

Drag down column C the formula

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

--

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