How to make this excel function generic?

P

P

Partizanin2018-04-12 21:23:32

excel

Partizanin, 2018-04-12 21:23:32

How to make this excel function generic?

=SUM(A3-C2;A4-C3;A5-C4)
How to make such a function generic so that it can continue counting up to A100-C99 without manually listing it?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Anton Fedoryan, 2018-04-13
@AnnTHony

=СУММ(A3:A100)-СУММ(C2:C99)

G

Gennady Glagolev, 2018-04-12
@GGlagolev

=sum(A3:a100; c2:c99*(-1))
Try something like this

Similar questions

L

lukoie2015-09-16 02:44:50

What shop script can take data from Excel? 1Reply

A

Alexey2017-08-23 22:51:38

How to start learning Excel VBA? 1Reply

A

Alexander F2017-08-25 10:18:33

How to parse .xls version 5.0 (BIFF5)? 1Reply

P

Protactinium2362017-09-25 16:48:01

How to write to memory or buffer JSON data of a parsed object via VBA-JSON? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question