SubTotal function counts the blank cells with formula

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

12-28-2019, 12:58 PM

p45cal

Windows 10 SubTotal function counts the blank cells with formula

Office 2019

Expert

Join Date: Apr 2014

Posts: 947

Quote:

Originally Posted by jeffreybrown

How can the cells be blank if it has a formula?

formula:
=""
1. is counted as a blank by COUNTBLANK
2. is counted as not being blank by SUBTOTAL(103,… (aka COUNTA).

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 11:35 PM.