SUM of cells that contain data

[komputer]

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.

[TABLE="width: 144"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1
[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="bgcolor: transparent, align: right"]7.5
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11
[/TD]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]13
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]17
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]18
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Kamolga]

If you have columns A,b,c and rows 1 to 18, then your workdays are the amount of cells filled with data in range B1:C18

=Count(B1:C18)

will count it for you.

 

[komputer]

Thanks, that i know.
Read a mine question please.
I need calculate 12 worksheets and only cells have data exclude row1

 

[kweaver]

Do you need the total such as Kamolga wrote on EACH of the 12 sheets or just the total on a summary sheet?
If the latter and if the sheets are contiguous, try:

=SUM(Sheet1:Sheet3!B1:B18)

 

[komputer]

If you have columns A,b,c and rows 1 to 18, then your workdays are the amount of cells filled with data in range B1:C18

=Count(B1:C18)

will count it for you.

Thank you, it not count as you tell
but i found solution in formulas
for me its looks as that
=COUNT(B,'SHEET NAME'!B2:B32)
as example but counting 12 sheets

Thanks anyway

 

[komputer]

Do you need the total such as Kamolga wrote on EACH of the 12 sheets or just the total on a summary sheet?
If the latter and if the sheets are contiguous, try:

=SUM(Sheet1:Sheet3!B1:B18)

Thanks, i found formula

 

[Kamolga]

Basically you just need to select 12 sheets (click sheet 1, press shift, then sheet 12) and type formula to have the count on 12 sheets. Sheet1:Sheet12 to have the count of 12 seets.