Hi,

Try putting this in D2 and copying it down:

=IF(OR(C2="",C3=C2),"",B2+IF(C2=C1,B1))

Where I assume you have titles in row 1.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JB Akron" wrote:

I need to add data if sites match in one column (C). If they match, then
corresponding cell data from Column (B) are added together and as a sum in
Column D. If there is not a duplicate match it would be great if the cell
just carried over to Column D. The duplicates are not consistent and single
sites are intermixed. Column B is numeric, Column C is text

Example

B C D
1 s234 1

2 s235
5 s235 7
4 s236 4
5 s237
1 s237 6


Thank you for your input.