I'm attempting to determine how many rows in a spreadsheet have at least one non-blank value distributed across a few columns, i.e.

```row 1 has a text value in column A
row 2 has a text value in column B
row 3 has a text value in column C
row 4 has no values in A, B or C```

Because rows 1, 2, and 3 all have a text value in at least one column, the algorithm would result in 3. Similar to how row 1 would count as one if each of the columns (A, B, and C) contained a text value.

Dec 26, 2022 in Others 60 views

## 1 answer to this question.

With formulas, what you can do is:

• in a new column (say col D - cell D2), add =COUNTA(A2:C2)
• drag this formula till the end of your data (say cell D4 in our example)
• add the last formula to sum it up (e.g in cell D5): =SUM(D2:D4)

I hope this helps you.

• 53,160 points

## How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

## How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

## How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

## How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

## Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

## Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE