Hi everyone.
Boring to count all the cells contain data.
I have a worbook where marking my workdays and workhours.
Once a year i have to calculate my workdays in SUM.
In workbook have sure have for a year 12 worksheets.
Any solution of formula for last month of year in separate cell ?
Some example: first row is month days, second and third is my workdays with hours. So i need calculate only cells which contain data in second and third columns.
<tbody>
</tbody>
Boring to count all the cells contain data.
I have a worbook where marking my workdays and workhours.
Once a year i have to calculate my workdays in SUM.
In workbook have sure have for a year 12 worksheets.
Any solution of formula for last month of year in separate cell ?
Some example: first row is month days, second and third is my workdays with hours. So i need calculate only cells which contain data in second and third columns.
1 | ||
2 | ||
3 | 9 | |
4 | 8 | |
5 | 8 | |
6 | 7.5 | |
7 | 7 | |
8 | ||
9 | ||
10 | 6 | |
11 | 6 | |
12 | 8 | |
13 | 8 | |
14 | 8 | |
15 | ||
16 | ||
17 | 8 | |
18 | 8 |
<tbody>
</tbody>