Counting attendance

rafuk73

Banned
Joined
Aug 10, 2010
Messages
47
Hi, all!

Could you please help with one formula please

I have a table which looks like this:


.....A.........!......B.........!........C....... !.........D...........!.......E........!
1..............!.1 June 2009! 14 Aug 2009!...6 June 2010...!..2 July 2010!
2...Pete.....!...Attended..!.................!....Attended......!.................!
3...John.....!.................!..Attended...!....Attended......!.................!
4...Lisa......!...Attended..!..Attended...!......................!...Attended..!

I need to add two columns after the names with a formula which would count how many times eact person attended the event in 2009 and 2010.
I need to keep the range in all formulas the same as the table can expand with new dates, so for example (Pete's attendace) =COUNTIF (B2:C2, "Attended") for 2009 and =COUNTIF (D2:E2, "Attended") for 2010 are not good enough. I need to have the same range for all formulas.

Kind regards
 
Last edited:

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,109
Messages
5,857,439
Members
431,879
Latest member
KiwDaWabbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top