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

M

Mnq2232019-07-10 20:43:29

Excel file in Wordpress? 3Reply

P

Pavel2019-07-10 21:40:36

How to merge all files in google drive? 1Reply

D

Danil O'neil2021-02-17 19:34:02

Excel places the artifacts on top of the cell. What is it and how to remove it? 2Reply

V

Vlad2019-07-12 13:25:23

How to build a graph based on this data? 0Reply

M

MisTFoR2021-02-19 09:17:48

How to erase a word up to a certain character in Excel? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question