Excel help...formula

Reply #6

SergeM — Tue, 02 Jun 2015 20:06:29 GMT

= countif( selection-range , X )

That is sufficient. You don't need it in percentages.

Reply #5

dad0519 — Tue, 02 Jun 2015 20:01:50 GMT

Thursday Friday Saturday Sunday Monday Tuesday Wednesday

X X 100.00%

X 100.00%

#DIV/0!

Row 3 has an X in the Thursday and Saturday Column. But if today is Saturday the should only be showing 66% compliant. Row 4 should only be showing 33% compliant... Row 5, I want it to read Non-Compliant

Reply #4

winsumloosesum — Tue, 02 Jun 2015 18:48:31 GMT

Not sure if this is what you need:

https://app.box.com/s/t3ri3zgvrjr9pgxl7kcrrez66qibz65y

I have a list of numbers and letters in cell range A1 through A100

In cell C1 the formula is:

=SUM(COUNTIF($A$1:$A$100, 0 )/COUNTA($A$1:$A$100))

Right click the cell C1, select the Number Tab, Select Percentage, I selected 1 decimal place.

Reply #3

Raven62 — Tue, 02 Jun 2015 18:07:09 GMT

(Number of Cells containing Text Divided by Total Number of Cells) Times 100 Equals Percent of Cells Contains Text.

Reply #2

SergeM — Tue, 02 Jun 2015 15:56:27 GMT

Good question for general Excel-function use.

The name of the function doesn't match the general understanding of the function-name.

You just put slime fish in the boat.

Reply #1

phileight — Tue, 02 Jun 2015 10:19:02 GMT

counta looks for some text you specify. It sounds like you just want to know if the cell is not empty, if so use countblank. this will return the number of blank cells in your specified range.

Excel help...formula

dad0519 — Mon, 01 Jun 2015 17:31:11 GMT

I'm trying to create a formula that gives the result of the number of cells in a row that contain text. For example if I have four cells in a row and three contain text the result would be 75%, if I have seven cells in a row and four have text the result would be 57%.

This is what I have so far... =COUNTA(B9:H9)/COUNTA(B9:H9