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  Reply With Quote

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.  Reply With Quote

3. Re: SUM of cells that contain data

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

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)  Reply With Quote

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  Reply With Quote

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  Reply With Quote

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.  Reply With Quote

User Tag List

Tags for this Thread

cells, data, sum, workdays, year  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•