I have a spread sheet with the following columns:
A - City Truck is in
B - Qts of oil needed
C - Oil allocated?
I have a report built into a spreadsheet that totals all of the qts of oil needed by City. I did this using the countif function. countif(A10:A1000,A1,B10:B1000). This works nicely but what I'd like to do next is put an "X" or "yes" in the C column when the oil is allotcated and have another cell in the report that shows how much oil is not allocated yet. In other words, I want to do the same countif function but this time not include the rows that a value in the C column.