![]() |
|
|
|
#1
|
||||
|
||||
|
Perhaps
Code:
=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100=3)+0)
__________________
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 |
|
#2
|
|||
|
|||
|
I don't get this one to work. I tried it as you put it and also with "B" instead of "A" since I'm trying to count the numbers in column B.
I always get the count 0 |
|
| Tags |
| countif, filter, solved |
|
|
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 |