Calculate monthly meeting attendance %

**mcrams1025** · 04-02-2011, 08:22 PM

I would like a formula to calculate the % of meetings attended by individual members on a monthly basis. What I am trying to do without success is to calculate a % by using the latest monthly meeting as the divisor in the formula not the total of months (12). Can anyone help or even understand the request?
Thanks in advance.

meetings attended/total monthly meetings held to date=%
I am having trouble calculating the divisor (total monthly meetings to date)

**martindwilson** · 04-02-2011, 08:28 PM

please change your title to something more descriptive "formula to calculate % on a monthly basis" would do this helps in future searches.

**mcrams1025** · 04-02-2011, 08:32 PM

Originally Posted by martindwilson

please change your title to something more descriptive "formula to calculate % on a monthly basis" would do this helps in future searches.

Can I edit the title of a thread?
Thanks

**martindwilson** · 04-02-2011, 08:35 PM

If you have registered, you will be able to edit and delete your posts. Note that the administrator can disable this ability as he desires. Your ability to edit your posts may also be time-limited, depending on how the administrator has set up the forum.

To edit or delete your posts, click the button by the post you want to edit. If your post was the first in the thread, then deleting the post may result in the removal of the entire thread.

After you have made your modifications, a note may appear, which notifies other users that you have edited your post. Administrators and moderators may also edit your messages but this note may not appear when they do so.

note we cant answer a post with "formula help as a title" or we get visited by a moderator like a high flying incontinent pigeon

**martindwilson** · 04-02-2011, 08:50 PM

thanx for title change but sorry i forgot to mention please post a sample workbook,its easier to see what you need.show expected result and where you expect the result to be calculated from

**mcrams1025** · 04-02-2011, 08:56 PM

Originally Posted by martindwilson

thanx for title change but sorry i forgot to mention please post a sample workbook,its easier to see what you need.show expected result and where you expect the result to be calculated from

done

would like the % of meetings attended at the end of each row for each member.

**martindwilson** · 04-03-2011, 05:13 AM

you could try
=(SUM(P2:P67))/(66*MONTH(TODAY()))

**mcrams1025** · 04-03-2011, 01:22 PM

Formula did not give the desired result. Thank you.

These formulae seemed to work:

=if(len(A2:A),mmult(index(B2):index(B:M,counta(A:A),month(today()))="x",sign(row(index(A1):index(A:M,month(today()))))),iferror(1/0))

and

=ArrayFormula(if(isnumber(N2:N),N2:N/month(today()),iferror(1/0)))

**martindwilson** · 04-03-2011, 02:10 PM

not sure how you came up with those
where does either of them go on your sheet? surely if no future months are used then you just need to count the no of x per person divided by the month of today
so =countif(d2:o2,"x")/month(today()) would give the % for wanda
i