How to add multiple columns based on criteria in rows

Hi All,

I'm trying to add figures in multiple rows based on multiple conditions at row level.


I did include an attachment cuase that is the easiest way to understand my issue. I know how to do this using indirect but my boss hates any file that has indirect in it!!!!

Many thanks inadvance