I am trying to add certain groups within a spreadsheet. For example:

A group will have a type and an amount. If the type is "Check" then I want
it to add the amount in the sum "Total Checks." If the type is anything
else, then I want it to add the amount in the sum "Total Everything."

How do I tell it to add all of the related amount cells for "Checks," but
not ALL of the cells with amounts? I have a temp setup right now with IF
statements, but I'm limited to 30 cells due to the formula length. I feel
like this should be REALLY easy.