Expansion to previous question (Find a row based on multiple criteria and then sum up items that are in that row to the right

[agcoleman]

I posted a question a few days ago and it was solved. See link Find a row based on multiple criteria and then sum up items that are in that row to the right.

I would like to expand on that formula by only summing up columns that meet a certain criteria in row one. For example, if the first two columns in the original post had january above them and the second two had February I would like to be able to return the values for just january.

 

[agcoleman]

This image shows what I am trying to sum up. I am already using the sum/filter functions in combination with the helper cell so that I can find a specific row based on all of the criteria in columns B through U. SUM(FILTER(Actuals!$W$3:X$230,Actuals!$V$3:$V$230='Piping Weekly'!$V$10)
Now I would like to be able to still find a certain row based off of the helper cell and then only sum up the columns that have a certain month in row 1.
I was trying to use some kind of combination of the Sum/Filter and a Sumproduct formula. But i can only figure out how to get the sumproduct to reference the row that is chosen and not one based on the helper cell.

 

[agcoleman]

I ended up figuring out the formula. I put the Filter function as the second array of a sumproduct/if formula.
=SUMPRODUCT(--(IF(Actuals!$W$1:$ES$1='Piping Monthly (2)'!W$5,FILTER(Actuals!$W$3:$ES$230,Actuals!$V$3:$V$230='Piping Monthly (2)'!$V8,0))))