Share via

Excluding "function" cell from column calculation

Anonymous
2014-12-22T19:55:14+00:00

Hi! I have a column with values in column K (K1:K98). When I enter a function to calculate column K it does not output a value. I think the reason is that I am inputting the function in K99, which is not part of the data. How can I specifically exclude this cell (K99) from calculation. Is there any specific variable I can input with the formula to exclude K99.

Your help is much appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-23T19:24:21+00:00

    It will most definitely work for AVERAGE().  It should work for XIRR() also.  We need SPECIFIC examples of where and how you are using these formulas. 

    Tell us what cell the AVERAGE() formula is in (if there really is one), and then tell us what cell the XIRR() formula is in, and show us what it looks like now.

    If it (the XIRR() formula) is in K99, then if the values are in K and the dates are in column M, then the formula should look something like this:

    =XIRR(INDIRECT("K2:K" & ROW()-1),INDIRECT("M2:M" & ROW()-1))

    this would be the same as writing

    =XIRR(K2:K98,M2:M98)

    Was this answer helpful?

    0 comments