Share via

How to count the total number if we have same title.

Anonymous
2020-06-13T13:27:56+00:00

Hi

I want to find out the total count of the title if the title contains keywords like Software Development or Software engineering etc. irrespective of company name and seniority level for the below data:

Company Name Title Count
ABC Director, Software Development 10
XYZ Senior Director, Software Engineering 50
ABC Vice President, Software Development 15
ABC Senior Director, Software Engineering 14
XYZ VP, Software Engineering 15
ABC Software Development 17
ABC Executive Director, Software Development 20
ABC SoftwareEngineering (No space between software and engineering) 50
XYZ Cyber Security 40
XYZ CyberSecurity 20
ABC SoftwareDevelopment 60

Total count if the title contains Software Development or Engineering?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-06-13T13:37:38+00:00

Hello Avinash

I am V. Arya, Independent Advisor, to work with you on this issue. Populate your keywords in a column and use following formula (For multiple keywords, sum the different results)

=SUMIF($B$2:$B$12,"*"&E2&"*",$C$2:$C$12)

The below formula is applicable if you are excluding SoftwareEngineering, Softwaredevelopment

But if you want to include them also

=SUMPRODUCT(ISNUMBER(SEARCH(SUBSTITUTE(E2," ",""),SUBSTITUTE($B$2:$B$12," ","")))*($C$2:$C$12))

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2020-06-13T13:31:47+00:00

With the Title column in column B try =COUNTIF(B:B, "*software development*") to get a count of the titles containing software development.

For a sum of the Count in column C change to a SUMIF or SUMIFS.

=SUMIFS(C:C, B:B, "*software development*")

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-13T13:34:35+00:00

    Thank you so much :)

    Was this answer helpful?

    0 comments