Combined keys might be an option to reduce time for the macro. I will try it.
Anyway, I can#t really change the original data sheets, so I either have to
work with copies or undo every modification after ... Thanks a lot for this
suggestion!

"Nigel RS" wrote:

Hi,
Have you considered creating a combined key using ABC then sorting this list
and then totalising D ?

"Axel" wrote:

Hi,

I have the following problem. I have a big table and I want to add up let's
say values in column D, whenever Column A, B, C have a specific value (e.g.
A=US, B=CA, C=SF). (Actually I need summed up values for all combinations of
A, B, C)

I have a solution working with loops, but this takes a lot of time,. Does
anybody know a quicker solution (e.g. using some kind of find for 3 values or
something else ...)

Kind regards, AXEL