SUMIF Formula

[acool]

Hi Everyone,

I am trying to create a sumif formula which provides the sum for only the first occurrence of my "criteria" based on my data set on the right. While the criteria "Andrew, England" my have a sum of 7 based on the data set on the right, I would only like for that sum to display for only the first occurrence on the right. Any help or insight would be greatly appreciated! Thank You!

 

[Fluff]

How about

=IF(AND(A2=A1,B2=B1),"",SUMIFS(G:G,E:E,A2,F:F,B2))

 

[Joe4]

In case your values in columns A and B are not all consecutive (sorted), you could use this variation (in cell C1 and copy down):

=IF(COUNTIFS(A$1:A1,A1,B$1:B1,B1)=1,SUMIFS(G:G,E:E,A1,F:F,B1),"")