Calculate total that exclude matching criteria

[RLJackson]

I have 3 columns of data (ID, Time, Exclude), I need to sum the 2nd column (Time) but exclude the ones where the values in columns 1 & 3 match. I need a formula that will give me the total time minus the excluded values. This is just a sample of the data; column A will have hundreds of rows & column D will have up to 100.

 

[hagia_sofia]

Hello, would e.g. this work for you:

=SUM(FILTER(B2:B19,ISERROR(XLOOKUP(A2:A19,D2:D5,D2:D5))))

 

[RLJackson]

Yes, that worked perfectly

Thank you !!!