help calculating percentage of "x" in row C vs. Row D. with unknown cells filled out

[Valhyric]

Hi, I've read tons of other threads with no luck so hopefully this is new ground. I want to calculate the percentage of "x" in row C versus how many "x" are in row D with no idea how many cells will be filled out. This is so that I can fill out the list with as many "x" I need without having to adjust the formula every time to account for the amount of cells I have filled out.

I know there are a lot of similar threads but none show how to calculate the percentage between columns with an unknown amount of cells. thanks for any and all help.

[Valhyric]

maybe I should clarify. i want to mark a cell with an "x" to indicate that cell is a yes in our questionnaire. then I want a column of cells marked "x" that show that cell is a yes. Then I need the percentage of yes's and the percentage of no's. But I never know how many answers their will be so the sum of the cells that will be marked is unknown.

[:) Sixthsense :)]

This will tell you about the number of cells in A1:A15
=ROWS(A1:A15)

For getting the count of Number of Yes
=COUNTIF(A1:A15,"Yes")

For getting the count of Number of No
=COUNTIF(A1:A15,"No")

So For getting the Percentage of Yes the formula will be
=COUNTIF(A1:A15,"Yes")/ROWS(A1:A15)

So For getting the Percentage of No the formula will be
=COUNTIF(A1:A15,"No")/ROWS(A1:A15)

Change the rows reference A1:A15 to your desired range or entire column like ROWS(A:A)

[Valhyric]

sorry what I meant is that the number of cells with a yes or no should be treated as a variable because it changes. I know how many cells there are now but it will change daily.

[:) Sixthsense :)]

This will get the count of filled cells

=COUNTIF(A1:A15,"<>")

Or

=COUNTA(A1:A15)

If the above one is not the one which you are looking for then please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).