Please help with this formula

I have a spreadsheet; 25 participants for 31 days 
each participant must log a catagory (eg PC) the spread sheet count the 
number of PCs for the 31 days (eg. formula (=COUNTIF(E10:AI34,"PC")). 
Question how can I calculate how many participates have logged a catagory PC 
within the 31 days. 
0
sealy (11)
8/4/2007 4:30:01 PM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
442 Views

Similar Articles

[PageSpeed] 53

Hi C,

One way, Put  =COUNTIF(E10:AI10,"PC") in cell AJ10
And drag down to AJ34

Then in another cell of your choice put
=COUNTIF(AJ10:AJ34,">0")

HTH
Martin


"C Sealy" <C Sealy@discussions.microsoft.com> wrote in message 
news:13350DAB-8BEC-4731-B235-B4B95C80B910@microsoft.com...
>I have a spreadsheet; 25 participants for 31 days
> each participant must log a catagory (eg PC) the spread sheet count the
> number of PCs for the 31 days (eg. formula (=COUNTIF(E10:AI34,"PC")).
> Question how can I calculate how many participates have logged a catagory 
> PC
> within the 31 days. 


0
mtmw (348)
8/4/2007 11:52:35 PM
you could also try:
=SUM(--(MMULT((--(E10:AI34="PC")),TRANSPOSE(COLUMN(E10:AI10)/COLUMN(E10:AI10)))>0))

array entered w/Cntrl+Shift+Enter

"C Sealy" wrote:

> I have a spreadsheet; 25 participants for 31 days 
> each participant must log a catagory (eg PC) the spread sheet count the 
> number of PCs for the 31 days (eg. formula (=COUNTIF(E10:AI34,"PC")). 
> Question how can I calculate how many participates have logged a catagory PC 
> within the 31 days. 
0
jmb (270)
8/5/2007 4:00:01 AM
Reply:

Similar Artilces: