Drag formula - ignore blank cells

P

Paul

Dragging Formula

Can I drag a formula down and have it ignore any blank cells.

I have a sheet (2000+ rows) which are subtotal by name and then total
for costs.

When viewing the sub-totals I want to add a new formula to the right
then drag this ignoring the blank hidden rows.

Hope this makes sense
 
S

Sheeloo

Copy the formula
Select the range to copy
Press F5
Click SPECIAL
Choose 'Visible cells only' to omit hidden cells
Press CTRL-V
 

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

Copy addition formula of non-consecutive horizontal cells 2
How To Have A Cell Be Blank If... 2
Complicated Look Up (without making changes to the blank spaces in the table) 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Fill Series in Filtered Rows 2
Drag down formula 0
Keeping cells blank even though formula is input 3

Top