Please help me!
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.
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!!!
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 |
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!!!