wow , it works for me as i ave several cell that only have single data and i need it to sum with line break data cell. thanks btw