Count cells in excel with populated values

0 votes

I have an excel sheet, and I want to count the number of non-empty cells in each row. The problem is that some of those are made up of formulas but nevertheless appear to be counted.

The cells for instance: are A1, A4, A6, A8, A10

And I'm trying to use the simple formula of:

COUNTA(A1,A4,A6,A8,A10) 

 Can a correct my formula to disregard formulas and only count if the cell is actually populated with a number?

Nov 16, 2022 in Others by Kithuzzz
• 38,000 points
501 views

1 answer to this question.

0 votes

Use:

=SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<>""))
answered Nov 17, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,600 points
1,614 views
0 votes
1 answer

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,600 points
804 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 63,600 points
612 views
0 votes
1 answer

Conditions in Excel: skip cells with dates without a year

Both Google Sheets and Excel save dates ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
• 63,600 points
416 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
4,048 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,999 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,690 points
980 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,697 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,107 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
1,609 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP