csv - How to create a logic that substract results of two awk logics?

Question

I need help to subtract 2 of the awk result below. Could someone give me an insight?

1. Find the total of rows filtered by the specified word in 12th column
2. Find the total of rows filtered by the specified word in 12th column and has the specified date in column 13
3. Subtract 1 and 2 and print the result

This solves problem 1

awk -F ',' '$12 ~ /<WORD>/ {count++} END {print count}' file.csv

This solves problem 2

awk -F ',' '$12 ~ /<WORD>/ && $13 ~ /<DATE>/ {count2++} END {print count2}'  file.csv

Unfortunately, I'm not getting the result for problem 3 below.

awk -F ',' '$12 ~ /<WORD>/ {count++} END {print count}' file.csv; awk -F ',' '$12 ~ /<WORD>/ && $13 ~ /<DATE>/ {count2++} END {print count2}'  file.csv; awk {print $count-$count2}

Answer 1

If you run multiple awk commands, the variables used are not shared. If you want them to be shared, you could combine the commands into a single program:

awk -F ',' '
    $12 ~ /<WORD>/ {count++}
   '$12 ~ /<WORD>/ && $13 ~ /<DATE>/ {count2++}
   END {print $count-$count2}
' file.csv

However, your three specifications seem to simplify to:

print the number of the rows of a csv file file.csv which contain a specific word in column 12 and which do not contain a specific date in column 13

awk -F, '$12~/word/ && $13!~/date/ {n++} END {print n+0}' file.csv

where /word/ and /date/ are regular expressions that provide the required word and date respectively.