Is there a good sumif formula or a different formula that would be good to use for a range of criteria and the criteria is all different but specific to what totals I what pulled out of a larger listing?
looks like you got it. I use a similar code in vba to tally all like items, then remove all duplicates. the result is a total of each unique item. One advantage of doing this through vba is you can use an obscure column to get the info, then delete the column afterwards. I use mine to update all A's with 21, and all B's with 6, then i remove all duplicate A's and B's = tally of each item. I can lookup the code tomorrow if you like.