Microsoft / Excel

I have been trying to come up with the forumla that will do this last calculation to finish the spreadsheet but it is stumping me. I have 6 Columns (A, B, C, D, E, F) and three rows (1, 2, 3). I need a formula that will count A1 in the total marked for column A only if F1 is not also marked. I need this to work for rows 1-3. For example 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. Thanks for the help. This one is killing me. Jason

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.

I need to count a non blank cell in a column only if a certain cell in the corresponding row is blank. For example I am counting all non blank cells in column A. If the first cell in column A (A1) is not blank I would need to check a column in that same row F1, for example, to ensure it is blank. If it is blank then A1 should be counted in the total at the bottom of column A. If F1 is not blank then both A1 and F1 would not be blank and A1 would not be counted in the total of Column A. Hope this clarifies things.

=SUM(AND(ISBLANK(A1),ISBLANK(F1)),AND(ISBLANK(A2),ISBLANK(F2)),AND(ISBLANK(A3),ISBLANK(F3)))

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History