# Help with countif(s)?

#### leanheart

##### New Member
Hello, I am trying to return a 1/0 only the first time a person exceeded 5000 in a span of several months. For example, the person in A2 exceeded 5000 every month, but I only want to know the first time they did it. Thanks for any help you can provide.

Jan Hoodies.csv.xlsx
ABCDEFGH
1DealerIDJanfebmaraprMayJunJul
28178294117904013039.78483.638238106107163.5
3135514021822215007.912276.521753.520362.9516914
441812579788210287.684553980965955065
531742799754514073.883701683736151176
Jan Hoodies
Cell Formulas
RangeFormula
E2:E5E2=VLOOKUP(A2,'C:\Users\JohnFrank\OneDrive - Tiber River Naturals Inc\Desktop\[Apr Hoodies.csv]Apr Hoodies'!\$A\$1:\$E\$1007,5,FALSE)

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hi Leanheart,

Does this work for you?

LeanHeart.xlsx
ABCDEFGHIJ
1DealerIDJanfebmaraprMayJunJulFirst Over 5000
28178294117904013039.78483.638238106107163.59040
3135514021822215007.912276.521753.520362.951691414021
441812579788210287.6845539809659550657882
531742799754514073.8837016837361511767545
Sheet1
Cell Formulas
RangeFormula
J2:J5J2=INDEX(\$B2:\$H2,AGGREGATE(15,6,COLUMN(\$B\$1:\$H\$1)-COLUMN(\$A\$1)/(\$B2:\$H2>5000),1))

Hi & welcome to MrExcel.
Another option
+Fluff 1.xlsm
ABCDEFGHIJ
1DealerIDJanfebmaraprMayJunJul
28178294117904013039.78483.638238106107163.5feb
3135514021822215007.912276.521753.520362.9516914Jan
441812579788210287.684553980965955065feb
531742799754514073.883701683736151176feb
Lists
Cell Formulas
RangeFormula
J2:J5J2=INDEX(FILTER(\$B\$1:\$H\$1,B2:H2>5000),1)

Hi & welcome to MrExcel.
Another option
+Fluff 1.xlsm
ABCDEFGHIJ
1DealerIDJanfebmaraprMayJunJul
28178294117904013039.78483.638238106107163.5feb
3135514021822215007.912276.521753.520362.9516914Jan
441812579788210287.684553980965955065feb
531742799754514073.883701683736151176feb
Lists
Cell Formulas
RangeFormula
J2:J5J2=INDEX(FILTER(\$B\$1:\$H\$1,B2:H2>5000),1)
Thank you so much for your fast response! This definitely is what I needed.

Glad we could help & thanks for the feedback.

Hi Leanheart,

Does this work for you?

LeanHeart.xlsx
ABCDEFGHIJ
1DealerIDJanfebmaraprMayJunJulFirst Over 5000
28178294117904013039.78483.638238106107163.59040
3135514021822215007.912276.521753.520362.951691414021
441812579788210287.6845539809659550657882
531742799754514073.8837016837361511767545
Sheet1
Cell Formulas
RangeFormula
J2:J5J2=INDEX(\$B2:\$H2,AGGREGATE(15,6,COLUMN(\$B\$1:\$H\$1)-COLUMN(\$A\$1)/(\$B2:\$H2>5000),1))
Thanks for your help! I appreciate it greatly!

Replies
1
Views
281
Replies
0
Views
274
Replies
1
Views
263
Replies
15
Views
718
Replies
9
Views
332

1,203,757
Messages
6,057,178
Members
444,911
Latest member
Uncommon1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back