Subject: | Re: Help Counting |
Posted by: | Bryan Hessey (Bryan.Hessey.27kcja_1147216801.1866@excelforum-nospam.com) |
Date: | Tue, 9 May 2006 |
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 th
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 thi
> formula.
>
> I have names in column A and either a number or a word in column B th
> word is 'space'
>
> What i need the formula to say is count all the 'space' enterie
> against each name.
>
> so if jon appeared 10 times in the list and space apeared 4 tim
> alongside his name the result would be 4. Th names in column a ar
> jumbled please help
>
> than
--
Bryan Hesse
-----------------------------------------------------------------------
Bryan Hessey's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=2105
View this thread:http://www.excelforum.com/showthread.php?threadid=54046
None
Help Counting posted by Brento on Tue, 9 May 2006