Looking VBA code/formulas to find the sum of certain range with specific criteria

[susanstha]

Hello everyone,

Column A contains the the name of package name, column B contains document number and Column C contains the size of each document. What I seek is the sum of document size for those documents which belongs to the same package. If you click the dropdown arrow for column A (package name), there are 16 unique package names. For instance, for package name 30KBB_CSSS_0CBE.TSE3, there are 791 documents and i want to have the sum of document sizes for those 791 documents. Since there are altogether 16 unique package names, i am looking for better/faster way to find the sum of document sizes for documents of those 16 packages.
If I filter on each package and find the sum of documents for that package, then I have to do it 16 times ( in some case more than 100 times) and its going to consume lot of time. So is there any smarter and faster way?

Please find the enclosed file.

Thank you in advance. ☺

[mehmetcik]

Formula for D2 and then Fill Down

=SUMIF(B:B,B3,C:C)


Or to achieve the same without Duplicates

=IF(COUNTIF(B$1:B2,B2)=1,SUMIF(B:B,B3,C:C),"")

[Richard Buttrey]

See attached which uses a pivot table approach

There are some document sizes that have #N/A in column C hence the PT can't evaluate those. You'll need to ensure they are either blank or zero.

[susanstha]

Hello,
Thank you for your help.