Results 1 to 7 of 7

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

  1. #1
    New Member
    Join Date
    Apr 2009
    Location
    Finland
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool 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. #2
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #3
    New Member
    Join Date
    Apr 2009
    Location
    Finland
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUM of cells that contain data

    Thanks, that i know.
    Read a mine question please.
    I need calculate 12 worksheets and only cells have data exclude row1
    Last edited by komputer; Jul 9th, 2019 at 10:08 AM.

  4. #4
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #5
    New Member
    Join Date
    Apr 2009
    Location
    Finland
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUM of cells that contain data

    Quote Originally Posted by Kamolga View Post
    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. #6
    New Member
    Join Date
    Apr 2009
    Location
    Finland
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUM of cells that contain data

    Quote Originally Posted by kweaver View Post
    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. #7
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default 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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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