Can somebody help me adjust this formula:
=SUMPRODUCT((Data!$L$2:$L$400="CUSTOMER SUPPORT & SERVICES")*(Data!$E$2:$E$400="D"))
In some cells of the range I2:I400 is the word 'Grade' and I need the formula result not to count that particular line.
Grateful for any assistance.
=SUMPRODUCT((Data!$L$2:$L$400="CUSTOMER SUPPORT & SERVICES")*(Data!$E$2:$E$400="D"))
In some cells of the range I2:I400 is the word 'Grade' and I need the formula result not to count that particular line.
Grateful for any assistance.