CODEWITHSUNDEEP
excelif-statementexcel-formula
Ben Howard
Ben Howard

Reputation: 3

IF Logic test - Excel

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.

PICTURE_1

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

Many thanks

Upvotes: 0

Views: 58

Answers (1)

Ullas
Ullas

Reputation: 11556

You can use the SUMIF function.

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

Upvotes: 1

Related Questions