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

D

den56992020-11-24 13:18:43

Why in excel, which lies in a shared folder, changes are not displayed on another computer? 0Reply

M

Mikhail Lyalin2016-10-03 18:46:22

How to find in Excel all cells in which a particular word is used more than 1 time? 1Reply

@

@xaknet2014-10-04 21:33:12

Asp.net - Calculating columns and displaying result without reloading UserController GridView page? 3Reply

W

Worlding2016-10-09 13:39:08

How to transfer contacts from excel to google? 3Reply

K

kariisha_nn2020-12-01 00:11:38

What am I doing wrong? Why does it return 0? 1Reply

Didn't find what you were looking for?

Ask your question