Forum Discussion
Formua help: Count IF
The solution, assuming this is an ongoing issue, is to change the way you collect the raw data in the first place. It's a mistake, anyway, to have the entire address (street PLUS city PLUS mail code) in one cell. And as you've discovered, you can't "train people" to do it correctly.
Specifically, since it would appear that you use town or city name as the basis for your subtotals, make that a cell of its own, and use data validation (Data....Validation...) to restrict the possible entries to a single name. See the attached.
- Gemma TelferMay 19, 2020Copper Contributor
mathetes Thnakyou for getting back to me.
I know the best solution would be to change how we gather the info, The info is gathered on a serperate system and exported in this fashion so we are not able to change that. I will just have to stick to manually counting and keep asking for the way we gather to be changed.
Thank you 🙂
- SergeiBaklanMay 19, 2020Diamond Contributor
To count perhaps
=COUNTIFS($A$2:$A$8,"<>*"&D4&"*",$A$2:$A$8,"*"&D3&"*")for
To count as same address how Excel knows some addresses are the same?