SUMIF across multiple columns and one row

[ryxk1]

I need to sum where criteria is matched in 2 columns and 1 row:


[TABLE="width: 320"]
<tbody>[TR]
[TD="width: 64"]O[/TD]
[TD="width: 64"]P[/TD]
[TD="width: 64"]2016[/TD]
[TD="width: 64"]2017[/TD]
[TD="width: 64"]2018[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="bgcolor: #E7E6E6"]*[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]*[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>


Using the example above, I need to sum if column O matches ‘A’, column P matches ‘*’ and the first row matches ‘2017’. So the answer I should get should be 4+3=7.
<strike></strike>

 

[Marcelo Branco]

I agree, but if "*" is all that can be in the column I think it should be okay, or if possible, I would not use the wildcard character "*" and replace it with something else.

Agree 100% with the part in blue!

M.