Hi everyone, I got some help making a sumif function work earlier today and now it seems like it is, however, the 5 sums that are generated are off.
The first one grabs all the sums of column K for every ash tree in column G
=SUM(SUMIFS(K6:K935,G6:G935,{"Green Ash","White Ash","Ash"}))
The second counts sums of column K for every ash tree in column C where the word "poor" appears in column M
=SUM(SUMIFS(K6:K935,G6:G935,{"Green Ash","White Ash","Ash"},M6:M935,"*Poor*"))
The third counts sums of column K for every ash tree in column C where the word "fair" appears in column M
=SUM(SUMIFS(K6:K935,G6:G935,{"Green Ash","White Ash","Ash"},M6:M935,"*Fair*"))
The counts sums of column K for every ash tree in column C where the word "good" appears in column M
=SUM(SUMIFS(K6:K935,G6:G935,{"Green Ash","White Ash","Ash"},M6:M935,"*Good*"))
The fofth counts sums of column K for every ash tree in column C where the no word appears in column M
=SUM(SUMIFS(K6:K935,G6:G935,{"Green Ash","White Ash","Ash"},M6:M935,""))
All of that seems to work however the first sum pulls out 2186
The second pulls out 62
The thirds pulls out 82
The fourth pulls out 1831
The fifth pulls out 238
The way understand it the second through 4th sums should equal the first sum of 2186, but they add to 2213
Can anyone see where I've gone wrong? I've attached a sample file. Thanks!
Bookmarks