How to make a calculation in Excel of the necessary points?

N

nikfcsm2018-12-29 16:51:08

excel

nikfcsm, 2018-12-29 16:51:08

Hello, there is a table in which there is an availability column. It has a YES or NO (D6:D61) parameter .
How to write a formula so that the cells (E6:E61) are summed up if the column contains the value NO ?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

F

forspamonly2, 2018-12-29
@nikfcsm

SUMIF

Similar questions

A

Andrey Sergeev2020-02-03 22:23:54

How to publish a report in Microsoft Power BI? 0Reply

F

fandorin_official2020-02-05 12:47:34

How can I get the letter of a column from Excel according to a number? 2Reply

N

nikitoshq2020-02-06 15:59:49

How to write data to excel file in PHP? 1Reply

M

Max2017-09-23 10:07:49

How to organize and edit xlsx excel both in MS office and via url? 3Reply

R

Ruslan Bagautdinov2017-10-09 15:25:31

How to make a column with time from 00:00:00 to 23:59:50? 2Reply

Didn't find what you were looking for?

Ask your question