Forum Discussion
Thibault13
Jan 13, 2020Copper Contributor
Sumifs: change summed data automatically
Hello everyone, I want to automatically swap data in a column to sum it. I have 3 sheets: - Sheet 1 is a data sheet: in each column there are different information to log. - Sheet 2 is a speci...
SergeiBaklan
Jan 14, 2020Diamond Contributor
That doesn't matter how many rows do you have, 3 or 300 000. What matters is how filters are to be applied, all together with AND condition or by other way. If first, perhaps car registration shall be excluded from filters since this field defines all the rest.
Thibault13
Jan 15, 2020Copper Contributor
Hello Sergei,
For now I do not need to use the registration as filter but I may in the future. However, in my application it does not affect what I am trying to do.