Sure, the IF function works well enough. I wanted to simplify using SUMIF
since it seemed to be exactly what I want to do. But it must have some
limitation that I haven't figured out.

If A(n) not equal A(n-1), nothing happens in the corresponding C cell, and
that row becomes the first of the next sequence. The blank in the C cell
will help me find the discontinuances.

"JMB" wrote in message
...
you just have to switch the order

=IF(A2=A3,,B2+B3,"")

IF(test, condition if true, condition if false)

Do any of these formulas take you in the direction you want to go?


"Easydoesit" wrote:

why a2<a3 instead of a2=a3?
"JMB" wrote in message
...
Actually with an IF statement, you don't even need SUMPRODUCT (been a
long
day).

=IF(A2<A3,"",B2+B3)


"Easydoesit" wrote:

This is a re-send due to no reply before.

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 $B$(n-1) to $B$n. I
incremented
the SUMIF value by extending the formula from C2 all the way down.

=SUMIF(b2:b3,A3=A2,b2:b3)

What might keep the function from working properly?
--Dave.