Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Tweeted twitter.com/#!/StackWebApps/status/456392356296540160
title, body text, retaaging
Source Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

ARRAYFORMULA and COUNTIF on Google Spreadsheet

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to

=IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),)

to compute a percentage of "I"I inputs divided by "all<> (all other inputs"inputs) and I need to omit blank cells. The IFERRORIFERROR formula just keeps the cell blank until data is entered in the corresponding row.

I want this formula to extend to every new row of a column. I have used ARRAYFORMULAARRAYFORMULA before to automatically extend the formula to new rows but I can't figure out how to use it (or something else?) in this case.

Thanks in advance for any help!

ARRAYFORMULA and COUNTIF on Google Spreadsheet

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of "I" inputs divided by "all other inputs" and I need to omit blank cells. The IFERROR just keeps the cell blank until data is entered in the corresponding row.

I want this formula to extend to every new row of a column. I have used ARRAYFORMULA before to automatically extend the formula to new rows but I can't figure out how to use it (or something else?) in this case.

Thanks in advance for any help!

ARRAYFORMULA and COUNTIF

I have a formula:

=IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),)

to compute a percentage of I inputs divided by <> (all other inputs) and I need to omit blank cells. The IFERROR formula just keeps the cell blank until data is entered in the corresponding row.

I want this formula to extend to every new row of a column. I have used ARRAYFORMULA before to automatically extend the formula to new rows but I can't figure out how to use it (or something else?) in this case.

Source Link
Brian
Brian
  • 21
  • 2

ARRAYFORMULA and COUNTIF on Google Spreadsheet

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of "I" inputs divided by "all other inputs" and I need to omit blank cells. The IFERROR just keeps the cell blank until data is entered in the corresponding row.

I want this formula to extend to every new row of a column. I have used ARRAYFORMULA before to automatically extend the formula to new rows but I can't figure out how to use it (or something else?) in this case.

Thanks in advance for any help!