How to set a condition that excludes identical rows in the SUM() function, but leaves one of them?

A

A

Alexander Sitnik2021-02-10 12:33:12

Google Sheets

Alexander Sitnik, 2021-02-10 12:33:12

How to set a condition that excludes identical rows in the SUM() function, but leaves one of them?

=СУММЕСЛИМН(K:K;C:C;Z1;O:O;"<>"&Z1;D:D;Y3)
+ СУММЕСЛИМН(K:K;C:C;Z1;O:O;Z1;D:D;Y3)*1,5

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2021-02-10
@ForestAndGarden

Additionally, use the UNIQUE().

Similar questions

N

NIKOFF2018-03-21 17:22:11

How to prevent the same text from being entered in Google Doc? 2Reply

M

Mikhail2018-03-21 21:56:24

What's the easiest way to add a Google Spreadsheet row? 1Reply

A

ARSENIY_TR2021-07-16 12:14:54

How to send html email via script in tables? 1Reply

A

Alina Shah2021-07-16 16:21:47

How to spread the digits of a number into cells with an additional condition? 1Reply

P

pfedorov0310902021-07-28 11:37:00

How to create a Google service account? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question