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

How To Have A Cell Be Blank If... 2
Ignore blank celss in left function 2
Not able to drag formula to successive cells 2
Fill down visible cells only 4
Odd Formula copying Behavior 3
Help! Need to ignore 0s and blank cells in average formula! 2
ignore cells that are blank 4
Excel Concatenate with line breaks but ignore blank cells 3

Top