Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SMC123

  1. SMC123

    Excel: How do you SUM C only if A is unique?

    Thanks to both Ken and Zathras! Ken, I am trying to avoid having to enter exact values in my formula because there are too many variables. But I think if there were fewer variables, it would work. I think Zantras' solution will fit my situation best. And yes, I know there is a duplicate in...
  2. SMC123

    Excel: How do you SUM C only if A is unique?

    Hi all. Sorry for another "unique" question, but I couldn't find this answer anywhere. To find a SUM, I am using an array on a linked workbook that has 3 IFs in it, and it works great until I try to incorporate unique values. I need help adding the values in a column only if another...

Part and Inventory Search

Back
Top