SubTotal function counts the blank cells with formula

		Microsoft Office Forums > Microsoft Excel > Excel
SubTotal function counts the blank cells with formula

12-29-2019, 04:54 AM

p45cal

Windows 10 SubTotal function counts the blank cells with formula

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

You could try a formula such as:
=SUMPRODUCT(--(LEN($AC$10:$AC$29)>0))
but that would take no account of hidden rows.
This might work though:

Code:

=SUMPRODUCT((LEN($AC$10:$AC$29)>0)*(SUBTOTAL(103,OFFSET($AC$10,ROW($AC$10:$AC$29)-MIN(ROW($AC$10:$AC$29)),0))))

yuk.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUBTOTAL FUNCTION PROBLEM when add a new line on top	excelino	Excel	2	05-12-2018 03:15 PM
Formula for blank cells	datadummy	Excel	2	09-11-2017 10:19 PM
Help with Subtotal(103, ) formula and blank cells	zhl203	Excel	1	07-30-2014 03:40 PM
Formula to hide '0' from blank referenced cells	formuladummy	Excel	3	05-08-2014 02:33 AM
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 PM.