Finding sum of column items for 30 IDs out of say 100000 IDs

[excelros]

I have like 100000 rows of data and say about 20 columns. One of the column items is unique IDs which are some numeric like 23232323 and some alpha numeric like broxti234. Another column item is say the numeric count of each ID's amount due.

I want to find the sum of all the amounts for say 35 out of the 100000 IDs, without using filter (as going through the 1000000 and selecting all those 30 is not easy), please suggest?

[FDibbins]

you can do this using sumif() or sumifS(). 1st you will need a list of the ID's you want to sum, then follow the on-screen instructions given by excel

If you still have a problem, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[excelros]

Thanks - I did a vlookup and then sum. Thanks - sumif would also work.

Appreciate it.