Hi Mike,

Why don't you combine both SumIFs for A and B to get the result as 254..

Regards,
DILIPandey

<click on below 'star' if this helps>