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
The one which is not working is
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.
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)
Code:
=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!AS1:AS53)
I cannot do it after unmerge because I have to do this calculation for every 30 min for above 200 sheets.