Schedule totals to include hidden rows

[aviv3JLEU]

Hi,

Im working on an area schedule of an apartment building for a sales document.

I need the calculated and grand totals to include some hidden rows in the schedule that can not be visible.

Is this possible?

[barthbradley]

What method did you use to hide certain rows?

Filtering? If so, the info is not being reported in the Schedule at all and therefore cannot be quantified. So, I guess the question is how to quantify something that is not there. Do you understand you correctly?  If yes, that's a real brain-twister.    

[ToanDN]

Yes.  Use conditional format to mask rows.

[aviv3JLEU]

Thanks for the Help.

I tried to read up and play around with conditional Formatting to mask the row but couldn't get it to work.

could you explain how this should be done.

[barthbradley · Accepted solution]

You can black it out.

[ToanDN · Accepted solution]

Here is an example to mask the cell with MARK = E2.1.  You would repeat the same condition format for other columns to mask the entire row. 

I understand that it is not very intuitive and very time consuming.   Another way is using a masking region to cover part of the schedule on sheet.

[aviv3JLEU]

Managed to get it to work.

Easiest way, i think would be to use a masking region on the sheet as mentioned.

Thank you both again for the help.