It might sound counterintuitive, given that opening a window seems to be the quickest and easiest way to drop the temperature of your house ... windows are often mentioned as effective ways to ...

Absolutely. Opening up your windows is an effective form of flush ventilation (flushing the warm air out of your house) - so long as the air outside isn't warmer than the air inside your house.