Hi All,
Sorry if not clear but not sure how to word the question.
I am trying to put something in place on sheet 1 that a cell takes a calculated value from one of 2 differnt cells on sheet 2 depending on which of the two is populated with a value.
For example
Sheet 1 and cell H30 needs to show the result of a sum from Sheet 2 either cell K6 or K15 which ever has a value. The other will be blank.
Also if possible to have for multiple lines, so if cells K6 - K30 and then also K40 - K60
No problem with a single cell as =Sheet1!IK6 just what is the rest?
Many thanks
Sorry if not clear but not sure how to word the question.
I am trying to put something in place on sheet 1 that a cell takes a calculated value from one of 2 differnt cells on sheet 2 depending on which of the two is populated with a value.
For example
Sheet 1 and cell H30 needs to show the result of a sum from Sheet 2 either cell K6 or K15 which ever has a value. The other will be blank.
Also if possible to have for multiple lines, so if cells K6 - K30 and then also K40 - K60
No problem with a single cell as =Sheet1!IK6 just what is the rest?
Many thanks