Hi,

So I have a formula which contains a countifs that looks like this:

=COUNTIFS($AZ:$AZ,$AZ15,$AM:$AM,ABS($AM15),$AD:$AD,$AD15)

However, I want the formula to count values when ABS($AM:$AM)=ABS($AM15) but I get an error if I try to put ABS($AM:$AM) as my range. Is there anyway to set my range as the absolute value of Column?

I have also tried ABS($AM15:$AM1000).

Thanks,
Justin