Match criteria in Column A and count amount of remaining cells below

Addictions

Board Regular
Joined
May 27, 2018
Messages
58
Office Version
365
Hello,

I would like to match and find a criteria in column A from C1 cell, and then calculate how many cells has values below with including the found one.
By looking at the table below it should return count of 4.
Much appreciate your help.

ABCD
1Current Week29
2WeekData 1Data 2Data 3
324111
425222
526333
627444
728555
829666
930777
1031888
1132999

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
 
Last edited:

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Addictions

Board Regular
Joined
May 27, 2018
Messages
58
Office Version
365
Please ignore I found the way of doing it:

=COUNTIF($A$3:$A$11,">="&C1)
 
Last edited:

navic

Board Regular
Joined
Jun 14, 2015
Messages
235
Office Version
2013
Platform
Windows
Okay, never mind.
You're welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,462
Messages
5,487,024
Members
407,576
Latest member
aapnarritesh

This Week's Hot Topics

Top