Round-Trip Flights: Unfair Rules

I recently bought a round-trip flight from Chicago to Las Vegas, and back to Chicago. A week later, I found out that work was sending me there for the week leading up to my trip. So, now I won't be able to use the outbound half of my trip from Chicago to Las Vegas, because I will already be in Vegas. Airline rules (SpiritAir, and many others) require you to use the outbound portion of your trip for the return ticket to remain valid. If you can't fly outbound, your entire ticket must be canceled. You can reschedule your outbound leg, but you still must fly it in some way, and pay any fare difference and fees of course.

It's not like I'm trying to game the system. I'm not asking for a refund on half of my ticket. I'm willing to forfeit half my trip. The airline gets to keep the $200 I spent for the round-trip ticket, even though they are only flying me one way. They should thank me. They get to re-sell the outbound seat and make more money. But no. They want to take advantage of us and squeeze us for every cent. They prey on our vulnerability of being trapped.

I can't see how this is legal. A class-action lawsuit will eventually come about when someone more influential gets   screwed with this. Until then, the only thing I can do is fly Southwest.

http://www.flyertalk.com/forum/3943287-post8.html

7. Does no-showing a flight cancel your return reservation? 

a. (nsx) No. On Southwest, unlike other airlines, you can no-show the outbound half and still keep your return reservation. 

Booooo Spirit. Yeaaaa Southwest!!!

SUMIF() Criteria Example

The syntax to use a criteria can vary if you want to make it depend on another cell. Here are various examples of using the SUMIF() function in Google Spreadsheets and/or Excel.

Sum cells in column B if column A = 10.
=SUMIF(A1:A10,10,B1:B10)

Sum cells in column B if column A = what's in A2.
=SUMIF(A1:A10,A2,B1:B10)

Sum cells in column B if column A > 10.
=SUMIF(A1:A10,">10",B1:B10)
=SUMIF(A1:A10,">"&10,B1:B10)

Sum cells in column B if column A > what's in A2.
=SUMIF(A1:A10,">"&A2,B1:B10)
in reference to: Function list : Functions - Google Docs Help (view on Google Sidewiki)