hello,
I have table 1, and i want to fill in the total visits per week in table 2. I have filled in the values manually, however I wish to do this with a formula.
My conditions are:
If certain date, and "School" column is not empty then add the number of visits.
For example:
If date = 10-Dec or 11-Dec and respective value under "School" is not empty then add the number of visitors.
I appreciate the help.
Table 1
Table 2
I have table 1, and i want to fill in the total visits per week in table 2. I have filled in the values manually, however I wish to do this with a formula.
My conditions are:
If certain date, and "School" column is not empty then add the number of visits.
For example:
If date = 10-Dec or 11-Dec and respective value under "School" is not empty then add the number of visitors.
I appreciate the help.
Table 1
Week | Date | School | Visitors |
1 | 10-Dec | school1 | 10 |
1 | 11-Dec | school2 | 20 |
2 | 12-Dec | school3 | 30 |
2 | 13-Dec | school4 | 40 |
3 | 14-Dec | school5 | 50 |
3 | 15-Dec | school6 | 60 |
Table 2
total visits | |
week 1 | 30 |
week 2 | 70 |
week 3 | 110 |
