kishoremcp

2012-01-27, 12:20 AM

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

=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!K1:K53)

The one which is not working is

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

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

=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!K1:K53)

The one which is not working is

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