Vlookup and sum without repeating

  • Thread starter Thread starter eo Sull
  • Start date Start date
E

eo Sull

Dear all,

I have a list of data

name Days Car
John 5 Red
Paul 4 Blue
Paul 2 Red
Mike 2 Green

I want to write a formula which would add up all days for a person without overlapping i.e. Paul in row 3 would come out at 6 and zero in row 4. I could put filters on, sort the data etc but was wondering if a formula exists?

Thanks
Eoghan


EggHeadCafe - Software Developer Portal of Choice
Fun With OPML in ASP.NET
http://www.eggheadcafe.com/tutorial...ef0-bf3db36b3ee5/fun-with-opml-in-aspnet.aspx
 
With the data in columns A:B, I could use this formula:

=if(countif(a:a,a2)>1,0,sumif(a:a,a2,b:b))
 
Back
Top