zerocoolxp
New Member
- Joined
- Oct 27, 2006
- Messages
- 2
Hello everyone,
I need help with creating a formula for work. I'm trying to add the values in colum K but not all the lines. It needs to skip 1 row at a time.
This is my current formula:
=K8+K10+K12+K14+K16+K18+K20+K22
I noticed if I add a few rows between K8 and K22 they don't get added to the formula. Is there a way to automatically add the newly added rows to the formula without doing it manually?
I need help with creating a formula for work. I'm trying to add the values in colum K but not all the lines. It needs to skip 1 row at a time.
This is my current formula:
=K8+K10+K12+K14+K16+K18+K20+K22
I noticed if I add a few rows between K8 and K22 they don't get added to the formula. Is there a way to automatically add the newly added rows to the formula without doing it manually?