Count until

Copper Contributor

We have a data table that we are continually adding to, we would like to track the updates to this.

I was wondering if there is a way to countA in the table until a nominal date, at which point that number does not change.

 

We want to know how much we add each month without manually checking. Can excel be set to countA on the 1st of each month so we keep a record of the additions?

 

Thanks!

1 Reply

Hi @MBelshaw 

 

You can use Countifs() function to achieve your requirement:

 

=COUNTIFS(A:A,">=1/1/19",A:A,"<=31/1/19")

 

A sample file is also attached for your reference. Please let me know if it works for you.

 

Thanks

Tauqeer