DJFANDANGO
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
Good day all,
I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on.
So I get the information sent to me and I paste it into the cells A10:B18, and this gived me the 'Meetings Attended'
The only formula I'm using is =COUNTIF(B$10:B$18,"Mark"), and the same in the subsequent cells below with each "name" A2:A6
Hope this is not too long winded, and you guys can help me out with probably a VERY simple solution...
I'd really appreciate any help on this one, thanks
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
I'm trying to pull the weekly attendance of personnel, at the moment i do this manually (not clever enough to do the other bit), please see my screenshot of an example, I have on another sheet all the week numbers and dates they start/finish on.
So I get the information sent to me and I paste it into the cells A10:B18, and this gived me the 'Meetings Attended'
The only formula I'm using is =COUNTIF(B$10:B$18,"Mark"), and the same in the subsequent cells below with each "name" A2:A6
- - How do I get it to populate the info on the 'Week 01, 02, 03...etc"?
- - Is there a way of changing the =COUNTIF to pick up whats in the cell (A2:A6) instead of writing the name in the formula (B2:B6), as the names list changes from week to week?
Hope this is not too long winded, and you guys can help me out with probably a VERY simple solution...
I'd really appreciate any help on this one, thanks
Sheet 1
A | B | C | D | E | F | |
1 | Name | Attended | Week 01 | Week 02 | Week 03 | |
2 | Mark | 2 | 1 | 1 | ||
3 | John | 2 | 1 | 1 | ||
4 | billy | 2 | 1 | 1 | ||
5 | oscar | 1 | 1 | |||
6 | michael | 2 | 1 | 1 | ||
7 | Total | 10 | ||||
8 | ||||||
9 | Date | Name | ||||
10 | 17/01/2019 | John | ||||
11 | 15/01/2019 | Mark | ||||
12 | 17/01/2019 | Billy | ||||
13 | 20/01/2019 | Billy | ||||
14 | 21/01/2019 | Oscar | ||||
15 | 26/01/2019 | John | ||||
16 | 01/01/2019 | Michael | ||||
17 | 08/01/2019 | Michael | ||||
18 | 15/01/2019 | Mark |
<tbody>
</tbody>
Sheet 2
A | B | C |
Week 1 | 2018-12-31 | 2019-01-06 |
Week 2 | 2019-01-07 | 2019-01-13 |
Week 3 | 2019-01-14 | 2019-01-20 |
<tbody>
</tbody>