Test for outline level of cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an expression that will return the cell's outline level that can be
used for an array criteria, such as in =SUMIF() or =SUMPRODUCT() ?
 
AFAIK, not without using a macro.
_________________________________________________________________________
 
Thank you.

Is there a macro or VBA function that could interoperate with the SUMIF() or
SUMPRODUCT() worksheet functions, or would I have to replace them with my own
code that reads the outlinelevel property?

Should I post the question in the Excel programming forum?
 
You would have to write a custom function to return the outline level and
then you could use it like any ordinary Excel function.
_________________________________________________________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

returning text; alternative to sumproduct/sumif? 4
test expression for empty cell in =SUMIF() 12
In a formula how can I reference the outline level of a row? 1
Using SUM + INDEX in array formula 5
SUMIF with criteria "<>" & "=" 4
Sumif with Multiple Criteria 3
Inserting line breaks in outlines 12
How do I count a range of cells from another columns criteria 6

Back
Top