In a spreadsheet, how do I get a count total if there are two criteria? For example, in one column I want to count all the "1"'s if, in another column there is a "c".

Read up in Excel Help on Microsoft Query. You can use ths feature to do more complex queries of your data.