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!
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!