[Edit] So I kind of assumed everything would think order of operations automatically apply but I guess I should have stated that. Yes, assume natural order of operations and not addition before multiplication in this example. [/Edit]

I found this math puzzle from Monroe CC. All you have to do is arrange the digits 1 through 9 in the grid blow so that all six of the equations (3 horizontal and 3 vertical) are all true.

If you are stuck, try solving for just one row and one column and then moving your way forward. I’ll probably post the result in a day or two but feel free to submit your answer if you think you have it.

Popularity: 10%

[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]

For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.

I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.

Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.

Popularity: 12%

I was never a big fan of these types of problems on standardized tests when I was younger but the more you analyze the problems, the better your reasonable skills should eventually become.

Take this problem for example this image below. Can you determine which one is the odd one out?

The answer is after the fold.

Popularity: 8%

Popularity: 3%

The proof seems so obvious now.

Source: Abstruse Goose

Popularity: 9%