Hello guys,
I'm working with relatively large dataset (ten thousands of rows) and I need to sum up certain values (approximately a hundred of sums in total) from the data based on various criteria. I tried to use sumproduct which works correctly in this case, but terribly slowly as well.
Simplified version of the dataset is attatched.
Two criteria in columns A and B have to be fulfiled, numbers from certain columns are then added up. Number of columns to sum up varies, but they are always next to each other.
My (really time-consuming) solution of the problem is included as well.
I am looking for some combination of functions which could deal with the problem much more quickly.
Thank you very much for all your suggestions.
Bookmarks