I'm trying to sum

__filtered__values from column

**J**(course credits) based on unique values from column

**F**(unique course ID).

The desired result would return a count of

**3**unique values (courses) for column

**F**and a subtotal of

**10**(credits) for column

**J**.

A | B | C | D | E | F | G | H | I | J |

- | - | - | - | - | 8212 | - | - | - | 3 |

- | - | - | - | - | 8212 | - | - | - | 3 |

- | - | - | - | - | 9771 | - | - | - | 3 |

- | - | - | - | - | 7877 | - | - | - | 4 |

- | - | - | - | - | 7877 | - | - | - | 4 |

- | - | - | - | - | 7877 | - | - | - | 4 |

<tbody>

</tbody>

The formula listed below returns the unique count for column

**F**, but I don't know how to add a parameter that would include the sum

**J**based on

**F**.

{=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(

**$F$7**:

**$F$50000**,ROW(

**$F$7**:

**$F$50000**)-ROW(

**F$7**),0,1)),

**F$7**:

**F$50000**),IF(SUBTOTAL(3,OFFSET(

**$F$7**:

**$F$50000**,ROW(

**$F$7**:

**$F$50000**)-ROW(

**F$7**),0,1)),

**$F$7**:

**$F$50000**))>0,1))}

Any help would be greatly appreciated!!!