Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Sumifs formula excluding duplicatesI do not know why I was stuck on SUMIF. Thank you for sending this formula. It worked for what I needed!Re: Sumifs formula excluding duplicatesEach time the employee's name appears with the same % rate. Other employees could have the same % rate.Sumifs formula excluding duplicates What I need is a sumifs formula that will not include a value that shows up more than once. How can I pull the 15.00% only once with criteria 1 employee name and criteria 2 "403B" into a cell on a separate sheet? Right now with sumifs I get 30.00%. Solved
