I need a formula that is able to sum data from one table, that has to match criteria that is in another table.
If values from months January through December, columns A-L, in table 1 are greater than 0. Then I want to only select the months whose values are greater than 0 as my criteria, to calculate the values that populate for those months only in table 2 , for those same exact months.
I was thinking of using a sumifs in combination with a countifs but it does not work.
If values from months January through December, columns A-L, in table 1 are greater than 0. Then I want to only select the months whose values are greater than 0 as my criteria, to calculate the values that populate for those months only in table 2 , for those same exact months.
I was thinking of using a sumifs in combination with a countifs but it does not work.
