Help with Subtotal(103, ) formula and blank cells

		Microsoft Office Forums > Microsoft Excel > Excel
Help with Subtotal(103, ) formula and blank cells

FAQ

Thread Tools

Display Modes

07-30-2014, 03:40 PM

whatsup

Windows 7 64bit Help with Subtotal(103, ) formula and blank cells

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

Hi

3 options:
1. Refer your formula to column A =SUBTOTAL(103,A1:A4)
2. That's only possible if cells in column A are either empty or contain text, then you can count twice and substract results of numbers form the total:
=SUBTOTAL(103,B1:B4)-SUBTOTAL(102,B1:B4)

3. Modify your formulas in column B to =IF(A1="",#N/A,A1) (copying to the end of your list)
Now you can use =AGGREGATE(3,3,B1:B4) to count.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to hide '0' from blank referenced cells	formuladummy	Excel	3	05-08-2014 02:33 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
Each subtotal signature require only at last page for each subtotal.	aligahk06	Excel	0	05-07-2010 11:07 PM
Using both drop down lists and blank cells for text	voltarei	Word	0	03-18-2010 04:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 PM.