How to summary by ColumnA + ColumnB + ColumnC by VBA ?
 

How to summary by ColumnA + ColumnB + ColumnC by VBA ?
Column B and ColumnC are unsorted columns.
Column D is amount, need to summary.

I prefer using array or collection be build a summary list.

The number of data less than 1000 rows.

Column A Column B ColumnC Column D
6321002974 61901990 010-BT 1,510.00
6321002974 61901990 010-BT 3,628.59
6321002974 61901990 010-BT 4,239.76
6321002974 61901990 010-BT 2,527.06
6321002974 61901990 010-BT 1,611.77
6321002974 61901990 010-BT (10,118.32)
6321002974 61901991 010-BT 4,163.95
6321002974 61901991 010-BT 2,081.97
6321002974 61901991 010-BT 2,081.97
6321002974 61901991 010-BT 2,079.46
6321002974 61901991 010-BT (2,081.97)
6321002974 61901991 010-BT (2,081.97)
6321002974 61901991 010-BT (4,163.95)
6321002974 61901991 010-BT (2,081.97)
6321002975 61000000 130-BT 240.89
6321002975 61000000 130-BT 1,180.70
6321002975 61100000 130-BT 16.86
6321002975 61100000 130-BT 177.18
6321002975 61100000 130-BT 58.96
6321002975 61100000 130-BT 7.19
6321002975 61100000 130-BT 101.16