Compare 2 rows in Excel and Add total -

i working on spreadsheet in 1 row have numberical value representative of hours, second row (and every row after that) contains either yes/no word.

the question if able in third box add total values row has numerical values based on whether second row says yes?

you should use =sumif(condition_interval, condition, sum_interval) function.

i'm using pt-br version, =somase equal =sumif.

formula: =sumif(b4:h4, "yes", b3:h3)