Conditional Formulas

[spursrule68]

Basically I have cell O1 as total number of trades

However this is based upon how many rows from 5 onwards are filled in. How can I get the cell O1 to change based on how many columns have been filled in?

Cheers

[thinkspac]

Create a Dynamic Named Range and reference the Named Range instead of the normal "N5:N11034" in the formula.

[spursrule68]

updated question

[thinkspac]

Going off of your earlier post:

Go to the Formulas Tab and Select Name Manager > New.

Use a name for the range, i.e. "ProfitLoss" and place the following formula in the 'Refers to:' field -

Please Login or Register  to view this content.

- where "Sheet1" should be the name of your sheet you are working on.

Replace your formula to read

Please Login or Register  to view this content.

[thinkspac]

Ok, your question completely changed...

Where does your current data reside and where do you add additional data?