Hi,

=SUMPRODUCT(--('Consults
Tracking'!$N$5:$N$472="x"),--('Consults Tracking'!$D$5:$D$472="BU- Geropsych"))

"Help with cell function" wrote:

I need to copy this formula into 200 cells. =SUMPRODUCT(--('Consults
Tracking'!N5:N472="x"),--('Consults Tracking'!D5:D472="BU- Geropsych")) How
do I copy it to all the cells without it changing? Thanks