Need help in calculating the sum of times in different columns

kishoremcp

New member
Joined
Jan 27, 2012
Messages
1
Reaction score
0
Points
0
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.
 

Attachments

  • Testing.xlsx
    55.5 KB · Views: 15

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
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.
 
Top