Summing shows wrong values

[LFM123]

I imported some data to excel from a system. It seems to show wrong values when summing. All values are numerical. The values are sorted.

[#2 · Accepted solution]

I solved it with this function because the rows was filtered: =SUBTOTAL(9;Q5:Q154)

[#3]

@LFM123 

That does not look like 150 rows. Most of them are probably hidden/filtered.