Sum array (or something) based on multiple criteria

[NeewBie]

Hi,

Have a big problem - don't know If its possible to solve it with VBA. If the socialsec, date, fruit is same then save it into a temp or something sum quantity and print out as 1 line else different rows.

Have a sheet with following data:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 5
12345 2015-02-02 Apple 3
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Printout in Sheet2:

SocialSec Date Fruit Quantity
12345 2015-02-02 Apple 8
11223 2015-02-01 Banana 1
11223 2015-02-01 Pear 1

Is this possible to solve? Best way to solve it thru an array, or? Feels impossible with VBA.

Thanks for help!

 

[RonB1111]

Here's a non-VBA solution:
Enter in E2 and copy down:

=SUMIFS(D:D,A:A,A2,B:B,B2,C:C,C2)

Enter in F2 and copy down:

=IF(A2&"~"&B2&"~"&C2=A1&"~"&B1&"~"&C1,"Duplicate","Not Duplicate")

Now turn on AutoFilters and filter Col F for "Not Duplicates". Then hide Col D and put header names in E1 and F1.

 

[NeewBie]

Hi,

Thank you for the help but I need an VBA-script because this will be a part of my script. Do you think its possible to solve with VBA?

Please help!

Here's a non-VBA solution:
Enter in E2 and copy down:

=SUMIFS(D:D,A:A,A2,B:B,B2,C:C,C2)

Enter in F2 and copy down:

=IF(A2&"~"&B2&"~"&C2=A1&"~"&B1&"~"&C1,"Duplicate","Not Duplicate")

Now turn on AutoFilters and filter Col F for "Not Duplicates". Then hide Col D and put header names in E1 and F1.

 

[RonB1111]

Sorry, I thought your last sentence asked for an array solution. I'm not versed in VBA, perhaps another contributor can respond.