SUMPRODUCT with condition
I have 2 columns B="Points" and C="Grade" And i'm trying to find the formula to sum the products of all points*grade for grades >= 60.
I tried this formula with many others, with no success:
SUMPRODUCT((B2:B100)*(C2:C100)*(C2:C100=">60"))
Output is: 0
Anyone has suggestions ?
I have 2 columns B="Points" and C="Grade" And i'm trying to find the formula to sum the products of all points*grade for grades >= 60.
I tried this formula with many others, with no success:
SUMPRODUCT((B2:B100)*(C2:C100)*(C2:C100=">60"))
Output is: 0
Anyone has suggestions ?
No comments:
Post a Comment