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
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