Forum Discussion

LFM123's avatar
LFM123
Copper Contributor
Apr 29, 2024

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.
excel
Formulas and Functions
  • LFM123's avatar
    LFM123
    Apr 29, 2024
    I solved it with this function because the rows was filtered: =SUBTOTAL(9;Q5:Q154)
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 29, 2024

LFM123 

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

 

Resources