Please help with this formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C Sealy - 04 Aug 2007 17:30 GMT

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.

Reply to this Message

MartinW - 05 Aug 2007 00:52 GMT

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

>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.

Reply to this Message

JMB - 05 Aug 2007 05:00 GMT

you could also try:
=SUM(--(MMULT((--(E10:AI34="PC")),TRANSPOSE(COLUMN(E10:AI10)/COLUMN(E10:AI10)))>0))

array entered w/Cntrl+Shift+Enter

> 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.

Reply to this Message