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

R

random_object2020-06-29 12:51:39

How to add comments to an excel chart? 1Reply

F

fghosting882018-06-28 15:56:21

How to sum similar ranges? 1Reply

M

MrLumusss2021-10-05 14:20:17

How to get a pivot table containing rows from source table, one column of which matches records in another table? 1Reply

A

Alexander Balya2021-10-05 15:46:20

How to convert minutes to hours in excel spreadsheet? 2Reply

N

Nikolai Shevtsov2015-05-27 18:07:17

How to defeat host mismatch with HP MSA1500 drive? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question