Hello,
I was using a COUNTIF formula to count the number of times a number starting with a 3 or 4 is found in a row. Works fine until someone’s ID appears more than once. Is it possible to have a formula add the rows together if duplicated without adding a helper column with unique entries? The results I am looking for are in column F.
This is the formula I was using
COUNTIF(B2:D2,3&"*")+COUNTIF(B2:D2,4&"*")
I was using a COUNTIF formula to count the number of times a number starting with a 3 or 4 is found in a row. Works fine until someone’s ID appears more than once. Is it possible to have a formula add the rows together if duplicated without adding a helper column with unique entries? The results I am looking for are in column F.
This is the formula I was using
COUNTIF(B2:D2,3&"*")+COUNTIF(B2:D2,4&"*")
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ID | Input-1 | Input-2 | Input-3 | Results | |||
2 | 17777 | 33-2 | 44-1 | 2 | ||||
3 | 17333 | Audit | 36-1 | 1 | ||||
4 | 17444 | 47-1 | 1 | |||||
5 | 17555 | 41-2 | 1 | |||||
6 | 17666 | 32-1 | 33-9 | 3 | ||||
7 | 17666 | 44-5 | ||||||
8 | 17987 | 36-7 | 1 | |||||
Sheet1 |