Hi all,
I've got a 20,000+ row table in which I'm trying to add a column that keeps a count with criteria, but my COUNTIFS attempt didn't work with Years of dates in the criteria...
...so I used the following sumproduct, but its not efficient (i.e. causes excel to run slowly). Is there a way to use something that will run more quickly?
I've got a 20,000+ row table in which I'm trying to add a column that keeps a count with criteria, but my COUNTIFS attempt didn't work with Years of dates in the criteria...
Excel Formula:
=COUNTIFS(YEAR([Visit Date]),YEAR([@[Visit Date]]),[Visit Type],"Initial",[Patient],[@Patient])
...so I used the following sumproduct, but its not efficient (i.e. causes excel to run slowly). Is there a way to use something that will run more quickly?
Excel Formula:
=SUMPRODUCT(--(YEAR([Visit Date])=YEAR([@[Visit Date]])),--([Visit Type]="Initial"),--([Patient]=[@Patient]))