SUM of cells that contain data

komputer

New Member
Joined
Apr 5, 2009
Messages
19
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

<tbody>
</tbody>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.
 
Upvote 0
Thanks, that i know.
Read a mine question please.
I need calculate 12 worksheets and only cells have data exclude row1
 
Last edited:
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top