Forum Discussion
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...
Hello Sergei,
I have attached a simple file of what I am trying to do. I have 30 000 rows and 50 columns on the real one.
Thanks in advance for your help
Do I understand correctly that car registration is unique record? Or that could be, for example, two records: car registration A with color red and car registration A with color black?
- It is a unique record, for one car you can only have 1 color, 1 power etc.
Thank youWhen what shall be the logic of the dashboard? In your current one you sum on all car registration A AND color red. Which has no sense since car registration A is always red.
Or you mean sum with OR condition, e.g. car registration A OR color red. Which sums all A registrations and all red cars with other registrations.
- The filters are drop down menu, if you click on the cell you can adjust the result.
You have to imagine that the data sheet has thousands of line and i want to know how much driving time i have depending on all those filters