Forum Discussion

jwilkerson0612's avatar
jwilkerson0612
Copper Contributor
May 28, 2025
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...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    May 28, 2025
    =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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 28, 2025
=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.

Resources