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

R

RealSwift2015-08-28 16:57:17

Can Google Calendar sync with arbitrary (native) services? 3Reply

V

Viktor Familyevich2017-01-11 12:22:37

How to work with Excel in C#? 2Reply

A

Alexander Shilov2019-06-17 11:12:24

Where can I find the PROGNOZ Add-in for Excel? 1Reply

S

serheg2015-02-01 02:15:50

How to change 1 parameter in 100 excel files? 1Reply

K

KillAstronauts2015-02-03 19:50:11

How to put a table from Excel into an array of the program? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question