COUNTIFS : counting instances of a number after a particular date

Hi Everyone,

I'm trying to count the instances of a particular number but only after a specific date.


1-1-580949355 41024.282292 0
1-1-580882232 41024.279271 0
1-1-577473178 41024.278171 1
1-1-577356414 41024.278137 0
1-1-580753825 41024.277975 0
1-1-580669091 41024.276447 1
1-1-580849821 41024.275231 0
1-1-580757299 41024.273287 2
1-1-580949412 41024.272512 0
1-1-580790044 41024.272477 0
1-1-580955303 41024.272164 0
1-1-580918572 41024.268183 0
1-1-580919572 41024.266655 1 ---- problematic
1-1-580697295 41024.266597 0
1-1-580711118 41024.265949 1
1-1-580793069 41024.265046 1
1-1-580849795 41024.263819 0
1-1-580943360 41024.262662 0
1-1-580905614 41024.262118 0
1-1-580849779 41024.260926 0

I'm using the formula COUNTIFS($A:$A,A2,$B:$B,">"&B2)

Basically, it's working but there are a few numbers that it shows a result as 1 (the one highlighted above) even if the number does not occur at all in the sheet. Is there another way to do this?

Thanks.

If your date column is sorted as your sample shows, you don't need COUNTIFS(). You can use a simple COUNTIF().

=COUNTIF(A$1:A1,A2) in B2 and dragged down.

Just to point out again - it will work IF your date column is sorted as your sample shows.

You're welcome. Please mark your thread as SOLVED.

Originally Posted by Cutter

Just to point out again - it will work IF your date column is sorted as your sample shows.

You're welcome. Please mark your thread as SOLVED.

One last question. What if it wasnt sorted that way? What if the dates werent sorted from latest to earliest? What would I use?

In that case you would use the COUNTIFS().