I am trying to add column value in a sheet with a filter applied. The problem I have is that Excel is adding values for rows that have been filtered out rather than just those the filter is showing.
I am clicking on the first cell in the column and then doing,
Ctrl + Shift + Down in order to select the values on screen, but this is returning the following formula.
How can I apply this in order that I do not have irrelevant values as part of the range?