SubTotal function counts the blank cells with formula

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-28-2019, 09:48 AM

jeffreybrown jeffreybrown is offline

Windows 10 SubTotal function counts the blank cells with formula

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Quote:

it calculates the blank cells as well (which have the only formula in those cells).

It sure seems like this contradicts itself. How can the cells be blank if it has a formula?

Can you post a sample file? This will help clear up what we don't know/see about what you are working on.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:33 AM.