Forum Discussion
Formua help: Count IF
Hi All I am wondering if anyone can help please? I am trying to use data we gather on support we provide but cannot seem to get forumlas that I know work. At the moment we have to go through 200 ...
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 🙂
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?