Hi there,
I am wanting a bit of help to refine a formula so that I can count the number distinct values in a certain range. This will assisting me ascertaining people hours for a project that I am involved with.
I am currently using this formula =SUMPRODUCT(1/COUNTIF(H3:K353,H3:K353)) which works well except I need to be able to exclude particular values in that range. Can anybody explain to me how I would refine this formula to only include specific values in this formula? The list of distinct values I want to count is: MA, MB, EMW, SR, KF, HS, KR, EW, CM, JR & HO
Cheers,
Milos
I am wanting a bit of help to refine a formula so that I can count the number distinct values in a certain range. This will assisting me ascertaining people hours for a project that I am involved with.
I am currently using this formula =SUMPRODUCT(1/COUNTIF(H3:K353,H3:K353)) which works well except I need to be able to exclude particular values in that range. Can anybody explain to me how I would refine this formula to only include specific values in this formula? The list of distinct values I want to count is: MA, MB, EMW, SR, KF, HS, KR, EW, CM, JR & HO
Cheers,
Milos