Formula to sum a row of numbers by a letter within one cell

[jlyn123]

Hello,

I am looking for a formula that will sum a row of numbers (hours per week) depending on the name of the job and letter indication. Example below:

Project name: hours each month
AZ-P-Testing 10 10 15 20.... I want to sum this row based on the "P" within project name. I tried =SUMIF(B6,"*"&"P"&"*",C6:BB6) but this only pulled in the first number "10" it didnt sum for a total. Any ideas?

Thanks for the help!

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

What column is the project name in?
Also are you just looking to sum each row individually, or all rows that have a P in the project name?

 

[jlyn123]

Hello,

The excel version I am using is 2016 (16.05.5122.1000) 32-bit and I cant just update the version as this is my work computer and everyone is using the same version. The project name is in column B and I am wanting to sum that one row if a P is in the Project name. If there isn't a P then I wouldn't want to sum for me. Each row would have different amounts to sum if the project name has a P in it. I dont want to sum all row together if a project has a P just line by line if that makes sense.

Thanks for your response.

 

[Fluff]

The excel version I am using is 2016 (16.05.5122.1000) 32-bit

Thanks for that, please don't forget to update you account details to show this.

How about

=IF(ISNUMBER(SEARCH("P",B6)),SUM(C6:BB66),"")

 

[jlyn123]

I updated the version I am using like you mentioned above .

That worked - thank you so much for all your help!!! Really appreciate it!

 

[Fluff]

You're welcome & thanks for the feedback.