SUMIF problem
 

I am getting a 0 as my result, consistently. I have three columns. If
$A$n=$A$(n-1), I want to add the value in $C$(n-1) to $C$n. I incremented
the SUMIF value by extending the formula from D1 all the way down.

What might keep the function from working properly?

post the formula you are using

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379589

Sorry.

=SUMIF(c2:c3,A3=A2,c2:c3)
--Dave.

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1qpm6l_1118909109.064@excelforu m-nospam.com...

post the formula you are using

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379589

What exactly is your formula.

"Easydoesit" wrote:

I am getting a 0 as my result, consistently. I have three columns. If
$A$n=$A$(n-1), I want to add the value in $C$(n-1) to $C$n. I incremented
the SUMIF value by extending the formula from D1 all the way down.

What might keep the function from working properly?

If I am reading you correctly,I dont think you want a sumif function
put 0 or some other staring number in D1
I think what you want in D2 is
=D1+if(A2=A1,c2,0)
and copy down

another factor could be if either what looks like matches in Column A are
not really matches
for two cells which look identical A3 and A4?
in a cell enter
=A3=A4 if the answer is not true they are not identical

additionally column C could be text rather than numeric
if this is the case try

=D1+if(A2=A1,value(trim(c2)),0)


"Easydoesit" wrote:

I am getting a 0 as my result, consistently. I have three columns. If
$A$n=$A$(n-1), I want to add the value in $C$(n-1) to $C$n. I incremented
the SUMIF value by extending the formula from D1 all the way down.

What might keep the function from working properly?

If I am reading your posting correctky, I don't think you want Sumif
Try entering either =C1 or 0 in D1
and in D2 enter
=if(A2=A1,D1+C2,D1)

other things it could be is that even though the look the same A2 may not be
the same as A3
enter =A2=A3 (if they do look the same) if the answer is false. they really
aren't
Additionally column C may be text instead of numbers
try
=if(A2=A1,D1+value(trim(C2)),D1)

"Easydoesit" wrote:

I am getting a 0 as my result, consistently. I have three columns. If
$A$n=$A$(n-1), I want to add the value in $C$(n-1) to $C$n. I incremented
the SUMIF value by extending the formula from D1 all the way down.

What might keep the function from working properly?