# Thread: SUM of cells that contain data Thanks: 0 Likes: 0

1. ## SUM of cells that contain data

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.

 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

2. ## Re: SUM of cells that contain data

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
Code:
`=Count(B1:C18)`
will count it for you.

3. ## Re: SUM of cells that contain data

Thanks, that i know.
I need calculate 12 worksheets and only cells have data exclude row1

4. ## Re: SUM of cells that contain data

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:

Code:
`=SUM(Sheet1:Sheet3!B1:B18)`

5. ## Re: SUM of cells that contain data

Originally Posted by 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
Code:
`=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

6. ## Re: SUM of cells that contain data

Originally Posted by 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:

Code:
`=SUM(Sheet1:Sheet3!B1:B18)`
Thanks, i found formula

7. ## Re: SUM of cells that contain data

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.