Count the number of rows with a number? (1 Viewer)

[Number11]

I am trying to get this working i have a pivot that is showing at the moment three month columns.

I want to count the number of rows within the pivot that have data which is a number

=COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(R10:R150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(S10:S150000, "<>")-1 (i am using the 1- top removed the pivot totals)

does this look correct

 

[GPGeorge]

Spoiler:

I am trying to get this working i have a pivot that is showing at the moment three month columns.

I want to count the number of rows within the pivot that have data which is a number

=COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(R10:R150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(S10:S150000, "<>")-1 (i am using the 1- top removed the pivot totals)

does this look correct

More important than whether someone thinks it looks correct, would be how it works when you try it.

Does it work the way you want it to work when you try it?

 

[Gasman]

I am trying to get this working i have a pivot that is showing at the moment three month columns.

I want to count the number of rows within the pivot that have data which is a number

=COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(R10:R150000, "<>")-1 (i am using the 1- top removed the pivot totals)

=COUNTIF(S10:S150000, "<>")-1 (i am using the 1- top removed the pivot totals)

does this look correct

Ever considered using Google at all for any of your queries?

count rows that have a number in excel - Google Search

From the first link from the above search.

Ways to count cells in a range of data - Microsoft Support

support.microsoft.com