Microsoft Office Forums - View Single Post - SubTotal function counts the blank cells with formula

Thread: SubTotal function counts the blank cells with formula

View Single Post

Old

12-28-2019, 04:15 AM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2013

LearnerExcel uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 81

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

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.

Reply With Quote