sum if some columns if both 2 vertical references and 1 horizontal reference is there

[Dares2]

Hi
I am wanting to sum a group of columns on one sheet if the vertical value is 1. not blank and 2. equals a certain value (like a vlookup) on the criteria sheet and 3 looks at a row on criteria sheet if this cell is "TRUE" it adds this column with the rest. This is to achieve adding all the months in a budget range if criteria is met.
I did have a sumproduct function =SUM(IF(B9<>"",SUMPRODUCT(('P&L Act'!$B$13:$B$163=B9)*(Actuals)))) but this is adding all the columns instead of just some columns if the horizontal range is TRUE?
Thanks

 

[Chrisdontm]

Are you able to give examples of what is in the columns, or exactly where the columns are?

And what the "Actuals" consist of...

 

[Dares2]

Are you able to give examples of what is in the columns, or exactly where the columns are?

And what the "Actuals" consist of...

Thankyou I was able to solve both horizontal and vertical lookups with a sumproduct formula in the end

=IF(B24="","",SUMPRODUCT(('P&L Budget'!$B$12:$B$163='P&L Detail'!B24)*('P&L Budget'!$D$11:$O$11=$R$2)*('P&L Budget'!$D$12:$O$163)))

Either way thanks for the reply. I love this site!