Forum Discussion

Copper Contributor

Apr 29, 2024

Solved

Summing shows wrong values

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.

Formulas and Functions

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

2 Replies

Detlef_Lewin
Silver Contributor
Apr 29, 2024
LFM123
That does not look like 150 rows. Most of them are probably hidden/filtered.
LFM123
Copper Contributor
Apr 29, 2024
I solved it with this function because the rows was filtered: =SUBTOTAL(9;Q5:Q154)

Resources