Results 1 to 2 of 2

Thread: Need help in calculating the sum of times in different columns

  1. #1

    Post Need help in calculating the sum of times in different columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an excel file in which I have different time handeled for different users which is exported from a tool (COntains also some merged cells)
    I have a formula which is calculating the sum of chats handedled in a correct manner (Working good) but if I use the same kind of formula it is giving the value as 0 (Zero). Please help me in fixing the problem. I am attaching both the formulas (The working one and the not working one also)
    The first one (Working) is
    Code:
    =SUMIF('Page 1'!C1:C53,"Total",'Page 1'!K1:K53)
    The one which is not working is
    Code:
    =SUMIF('Page 1'!C1:C53,"Total",'Page 1'!AS1:AS53)
    I am also attaching the file for testing.

    I cannot do it after unmerge because I have to do this calculation for every 30 min for above 200 sheets.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Sorry, but why do you need to have the merged cells in there?

    Merged cells are HUGELY problematic in Excel, and this isssue is directly related to that feature. If you can get rid of the merged cells this would be a piece of cake.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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