idnum | scanner | base | count |
100142123 | J11099 | ||
100142123 | 547808 | ||
100142123 | H11219 | ||
100142123 | 750198 | ||
100141240 | J1134 | ||
100141240 | |||
100141240 | H11464 | ||
Hi I need help with above table.
Based on idnum(first column) I need a count of scanners associated to that ID.
So ideally, I would see 2 in column "Count" for the first ID
SUMIF is set up perfectly in terms of range,criteria,and sum range but Countifs does not have the same setup.
Please let me know if this is possible.
thanks!!