excel4.jpg

attached is a spreadsheet that I'm working on E-100 needs a total of all mixed oak from column h9:h11,h16:h18, ect. As seen not all species are mixed Oak so I've been trying to find a function that will add up totals only when Mixed Oak is typed in to the B6, B13, ect. Sumif doesn't work and using just if() works but it ends the calculation as soon as it is added for the first set of numbers

Got any ideas? Thanks