Count only numbers in filtered column

		Microsoft Office Forums > Microsoft Excel > Excel
Count only numbers in filtered column

05-15-2017, 08:21 AM

NBVC

Windows 7 64bit Count only numbers in filtered column

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(GY10:GY1048576,ROW(G Y10:GY1048576)-MIN(ROW(GY10:GY1048576)),,1)),(GY10:GY1048576>1)*I SNUMBER((GY10:GY1048576)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count # of times "text" is in 1 column is specific date is in the other column	ann.acornacchio	Excel	4	12-31-2016 05:40 PM
Sum the (filtered) remaining work column	brentcfocus	Project	3	03-21-2016 08:34 PM
choose numbers from a set that must count up to 124	adragner	Excel	1	12-30-2013 09:51 AM
count w and write into another column in excel	tomlam	Excel	5	10-07-2012 06:09 AM
Character count without numbers	student	Word	1	05-10-2012 01:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:01 PM.