How to make in Excel, +=+1 to the total number, and -=-1?

I

I

Ilya Borisenko2019-10-05 13:55:32

excel

Ilya Borisenko, 2019-10-05 13:55:32

How to make in Excel, +=+1 to the total number, and -=-1?

Good day! There is a table which consists of "+" and "-". You need to make sure that the cell with "+" counts as +1 to the total value, "-" - -1, etc. The end result should be a number.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

dollar, 2019-10-05
@lilovij

Another column with =ЕСЛИ(A1="+";1;-1)
Further summarize.

Similar questions

B

B_M2018-10-29 17:03:03

Is it possible to get data from Viber with a macro in Excel? 3Reply

N

Nastushik2020-09-09 21:10:06

How to import tables on each new sheet of an excel book and, when re-importing, if the numbers match, add a line where the numbers match? 0Reply

M

Maxim2018-10-31 22:35:53

Why is the formula not applied? 1Reply

K

Kremenman2020-09-14 14:10:52

Application with entering data in Excel? 0Reply

N

Nikita2018-11-06 17:27:49

How to save cells in excel file in Php ZipArchive? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question