|I am confused by a number of things in your post.|
Your said: I need a formula that will count A1 in the total marked for column A only if F1 is not also marked.
What do you mean by "marked"?
What do you mean by "count A1 in the total marked"?
You said: ...if A1 is marked and F1 is not marked the total for column A should be 1. If A1 and F1 are both marked than the value for column A should be zero.
You use the words "total for column A" and "value for column A". Are these the same thing? Neither of your desired results sound like a "total".
Please explain further.