I ran into the following problem in EXCEL 2010 and 2013:

- I have a very large file that is roughly 43,000 rows long
- I filtered the 43,000 rows to yield only specific types of items
- In a column to the right of the filtered data I pasted a relative formula in each row that added 3 at each row
- The quantities of items in each row was 3, so I thought the paste would yield a sum of all filtered items
- The formula paste actually took place in all 43,000 rows instead of just the visible filtered rows yielding an erroneous total (much larger)
- At least I think it is erroneous.

Should Excel paste the formula even in rows that have been filtered out and are no longer visible? If so, does that make sense? I suspect I am missing something, and would appreciate any inputs.



Thanks,