Forum Discussion
Solved
Countifs Partial Values
Hello! I have several salespeople and I am trying to calculate their monthly sales volume. So for instance, I have a column A1:A100 with their names. I have the proper formula to count those. The on...
=SUM(IF(C1=$A$1:$A$9,1,IF(ISNUMBER(SEARCH(C1,$A$1:$A$9)),0.5,0)))This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Using the same logic, would it be possible to sum the gross for their deals and split that when appropriate if those were listed in a separate column?