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...
StefanZechner From the help screens:
So, your formula is summing 100+200 for two rows that contain "Auto". Hence, 600.