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.
=SUM(Q16:Q1532)
How can I apply this in order that I do not have irrelevant values as part of the range?