if statement - IF Logic test - Excel

Question

I am wondering if anyone can help me. I am trying to create a in and out sheet for COVID-19 tests for our company and I can't seem to get it to work.

I am trying to do If cell = IN then add, else minus from the number.

Many thanks

Answer 1

You can use the SUMIF function.

=SUMIF(C:C,"IN",B:B)