Countif with filter

		Microsoft Office Forums > Microsoft Excel > Excel
Countif with filter

FAQ

Thread Tools

Display Modes

08-29-2014, 08:53 AM

Pecoflyer

Windows 7 64bit Countif with filter

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100=3)+0)

Be careful not to use double quotes ("3") which is a string

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

countif, filter, solved

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using =countif formula with drop down box.	wchristner	Excel	0	02-19-2014 12:44 PM
COUNTIF Formula	teza2k06	Excel	3	02-13-2014 12:37 PM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM
Countif issue	Katy I	Excel	2	07-11-2012 06:30 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:11 AM.