Row Counting specific data

[jrake40]

I would like to count specific rows in a spreadsheet. For example see below..

Failed XMLs
tran_log_id origin_id reference_id result_code last_updated_dttm
11421022 OMS OMS_39794575 25 01:30.7
11421023 OMS OMS_39794575 25 01:47.2

I have repeated data with different titles and values. I would like to only count the bottom two rows. Is there a way to exclude the title and column headers when doing a row count. That is for this data I want a row count of 2.

 

[jrake40]

I am looking for VBA code that can do this for me.

 

[JeanKim]

Welcome to the forum.

From what I read, this can be done easily with formula. but!
can you explained in detail what is special about the row you are counting?

 

[jrake40]

I have a spreadsheet with different sets like the one above. So the titles and column headers change as well.
So my data rows are like this

Title
Colum headers
data
data
data

The data rows are variable but there is always one row with a title and one row with column headers. I only want to count the data rows.

 

[Aladin Akyurek]

Maybe:

=MAX(0,COUNTIFS(A:A,"?*")-2)

 

[jrake40]

That's the right idea but I need it to loop. So for each set of data I need it to -2 because there are multiple in the spreadsheet. I was thinking there has to be a way to code it for VBA.

 

[JeanKim]

I need it to -2 because there are multiple in the spreadsheet.

giving you code or formula is not really a problem but understanding what you need is.
I have no idea what you mean by above comment.

 

[jrake40]

If I had the following two sets of data in a spreadsheet. How could I count the rows only. The issue is that the rows and columns for each data set are different. That is in the first table I have 3 rows I want counted and the second table I have 5 rows that need to be counted.

Table 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]BB[/TD]
[TD]CC[/TD]
[TD]DD[/TD]
[TD]EE[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Table 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD]BC[/TD]
[TD]CD[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

The values in the cells do not matter to me so therefore I want a way I can count the rows. Just the row itself as 1. So in this case I would want it to give me a value of 8. Since there are 8 rows that contain numerical values ( 3 rows in table 1, 5 rows in table 2).

 

[Aladin Akyurek]

If you have to do with numbers...

=COUNT(A:A)

would probably suffice.

 

[JeanKim]

is tran_log_id in column A and always number?
if so =COUNTIFS(A:A,">0") will give you the answers
or just =COUNT(A:A)