G
Guest
I need a formula to give total records of a column except blank cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Look at COUNTA function.
G
Guest
what will the formula be. I have A2:A35 but A20 is blank i dont want it to
count A20
count A20
D
David McRitchie
Hi Jessica,
Records is meaningless in the context of your question
in Excel terms, you are looking for cells with content.
When you look at suggestion consider also that ISBLANK in Excel,
or ISEMPTY in VBA means that the cell has no content. A cell with
a formula or a cell with a space(s) or a single quote to denote
a null text string all have content so would not be ISBLANK.
see John Walkenbach's page:
Tip 74: Summing and Counting Using Multiple Criteria provides a number of
examples using SUMIF, COUNTIF, SUM that should solve most counting and
summing problems. Tip 52: Cell Counting Techniques provides information on
counting within a range using: DCOUNT, COUNT, COUNTA, COUNTBLANK, COUNTIF,
and includes one array formula example.
http://www.j-walk.com/ss/excel/tips/tip74.htm
The following may also be of interest:
Summarizing Data Examples (an Overview) -- on this site. Summarizing Data
Examples: Auto Filter with Hotel Room Availability Example, Pivot Table, Sub
Totals, Counts (COUNT, COUNTIF, SUM, SUMIF, SUMPRODUCT), Conditional
Formatting, Sum of Visible Cells. Has additional references at end.
http://www.mvps.org/dmcritchie/excel/sumdata.htm
Strings and Manipulations
http://www.mvps.org/dmcritchie/excel/strings.htm
Records is meaningless in the context of your question
in Excel terms, you are looking for cells with content.
When you look at suggestion consider also that ISBLANK in Excel,
or ISEMPTY in VBA means that the cell has no content. A cell with
a formula or a cell with a space(s) or a single quote to denote
a null text string all have content so would not be ISBLANK.
see John Walkenbach's page:
Tip 74: Summing and Counting Using Multiple Criteria provides a number of
examples using SUMIF, COUNTIF, SUM that should solve most counting and
summing problems. Tip 52: Cell Counting Techniques provides information on
counting within a range using: DCOUNT, COUNT, COUNTA, COUNTBLANK, COUNTIF,
and includes one array formula example.
http://www.j-walk.com/ss/excel/tips/tip74.htm
The following may also be of interest:
Summarizing Data Examples (an Overview) -- on this site. Summarizing Data
Examples: Auto Filter with Hotel Room Availability Example, Pivot Table, Sub
Totals, Counts (COUNT, COUNTIF, SUM, SUMIF, SUMPRODUCT), Conditional
Formatting, Sum of Visible Cells. Has additional references at end.
http://www.mvps.org/dmcritchie/excel/sumdata.htm
Strings and Manipulations
http://www.mvps.org/dmcritchie/excel/strings.htm
G
Guest
=COUNTA(A2:A35) will give count of the non-blank cells in this range. If A20
is blank, you will get an answer of 33.
Is this what you require?
is blank, you will get an answer of 33.
Is this what you require?
D
David McRitchie
Please use your Excel HELP (F1), you should have been able
to use "Toppers" reply.
=COUNTA(A2:A35)
to use "Toppers" reply.
=COUNTA(A2:A35)