خرید بک لینک

Say I have countries, values and status of the value and I want to sum the values when they relate to a particular country and are "Approved", what is the formula I would use?

Column A-C is the data and E-F is the total/summary. "FORMULA" is where I would like the formula to go.

DATA   A          B       C                   D          E
 1   Country    Value   Status              Country    Total Approved
 2   Germany    100     Approved            Germany    FORMULA
 3   France     150     Approved            Portugal   0
 4   UK         130     Not Approved        UK         100
 5   Portugal   200     Not Approved        France     150
 6   Germany    200     Approved
 7   Germany    300     Not Approved
 8   UK         100     Approved    

برچسب: نویسنده: استخدام کار تاريخ: جمعه 3 ارديبهشت 1395 ساعت: 19:12

صفحه بندی