Help Counting

Giganews Newsgroups
Subject: Help Counting
Posted by:  Brento (Brento.27k9am_1147212602.379@excelforum-nospam.com)
Date: Tue, 9 May 2006

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?action=getinfo&userid=25213
View this thread:http://www.excelforum.com/showthread.php?threadid=540468

Replies