Thread: Count only numbers in filtered column
View Single Post
 
Old 05-16-2017, 04:58 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try:

Code:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(GY10:GY1048576,ROW(GY10:GY1048576) -MIN(ROW(GY10:GY1048576)),,1)),--((GY10:GY1048576="M")+(GY10:GY1048576="B")))
Reply With Quote