@SPILL! Error - Count If

[Nanogirl21]

I am getting an error when using the below formula. Can someone help.

=IF('Raw Data'!F:F="NA",COUNTIF('Raw Data'!X:X,"OnTime"),"0")

If Raw Data'!F:F is equal to NA then count how many times the corresponding line says OnTime in Raw Data'!X:X

Sometimes column F will say NA, but X will say Delayed. I do not want to count this.

 

[Nanogirl21]

Nevermind! I actually figured it out -

=COUNTIFS('Raw Data'!F:F, "NA",'Raw Data'!X:X, "OnTime")

. Thank you