Add data if column Match
That only works if there are 1 or 2 like items in column C. If there's more
than 2 you'll get incorrect results.
What should happen if there is something like this:
B....C.....D.....E
1.....x...............
1.....x.....2........
.........................
2.....x...............
5.....x.....7......9
Should the result be that as shown in column D or that as shown in column E?
Or, will that not happen?
--
Biff
Microsoft Excel MVP
"Shane Devenshire" wrote in message
...
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.
|