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)

Quotapalooza.com

Currently engaged in a month-long quoting duel with a good friend of mine, Alan Slavik. Every day we each post a new original quote... hopefully something thoughtful and/or witty. It's been a lot more difficult than I expected to come up with something worth posting. Check it out, there are some really good quotes in the mix (all of the good ones are Alan's).

Here's a taste...

"Forgetting is merely the lack of remembering something at a specific time"

"Never trust a person that flosses every day."

"It’s ok to make the same mistake twice…especially if it was a lot of fun the first time around"

http://www.quotapalooza.com

Enjoy.

Undue Burdon on IL Taxpayers

Doing my state taxes now. Came across a new item called Use Tax, or UT (aka, internet tax). They want to tax us on any item we purchase outstate. Check out the wording from the IL-1040 instruction booklet.

How do I determine the Illinois Use Tax I owe?

To determine the Illinois Use Tax you owe, check your records to see if you were charged tax on internet, mail order, or other out-of-state purchases and use the Use Tax (UT) Worksheet to calculate your tax. If your records are incomplete and you had major purchases, add the actual cost of your major purchases to the estimated cost of any other purchases you made during the year. Enter the total on Lines 1a or 2a of the UT Worksheet to calculate the use tax you owe. no major purchases, use the UT Table to help you estimate the use tax you owe. Enter the Illinois Use Tax from the UT Worksheet or UT Table on Form IL-1040, Line 22.

Note: If we find that you owe additional tax, we may assess the additional tax plus applicable penalties and interest. We conduct routine audits based on information received from third parties, including the U.S. Customs Service and other states.

They actually expect us to keep records of what we buy. And at the end they try to scare us by threatening penalties and interest if they find out we owe more. I guess Duty Free is no longer free, you'll have to pay 6.25% if you live in IL.


Booooo!!!! Get it on the collection end, or don't get it at all.

I love the IRS

The IRS is doing a great job! (really)


I received a higher refund than I submitted on my return, so I went to IRS.gov to "check refund status" to make sure it wasn't a mistake (I was worried they might withdraw the funds later). Not only did the IRS website confirm that they changed my refund, but they explained why, and provided links to help me back-track and learn from my mistake. 5-star customer service! Thank you! Keep up the great work!

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)

Who owns DNA?

Monsanto and other biotech companies are creating strains of grain with a specific DNA, patenting the DNA, and preventing farmers from replanting the offspring of the seeds. But can you really own DNA? And if mutations occur to the DNA, are the offspring really the same DNA?

No. (Technically, the answer may be yes, but I'm saying here that it should be No. And we should allow them to do that.)

The process for creating the DNA-specific seeds should be patentable, but once you buy the seeds, you should be able to do whatever you want with them. It just doesn't seem right that you restrict what people do with stuff they buy. (yes, I'm talking to you too, Apple).