SubTotal function counts the blank cells with formula

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

FAQ

Thread Tools

Display Modes

12-28-2019, 04:15 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit SubTotal function counts the blank cells with formula

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

SubTotal function counts the blank cells with formula

Hi,

I have to count the cells which have the data in column "AC" (range from "AC10" to"AC29"). But it calculates the blank cells as well (which have the only formula in those cells). How to resolve the issue.

The below is the formula:-

Code:

=SUBTOTAL(103,$AC$10:$AC$29)

Please help.

« Previous Thread | Next Thread »

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 12:21 AM.