Forum Discussion
SUMMEWENN Bereich / SUMIF Range Bug
In the attached file you can find an easy example, which in my eyes is a bug. Had to search a long time in a real planning file to find out about it. =SUMMEWENN($G:$J;B4;$J:$J) sums up not on...
Since you use two columns in criteria range, Excel expands in background sum range also on two columns and sums values in yellow cells here
Please use same size ranges, even better 1D ranges to avoid side effects.