A
A
arr0w2020-09-14 15:09:51
Google Sheets
arr0w, 2020-09-14 15:09:51

Counting the number of values ​​according to a condition?

How can I calculate the number of remaining "working" (values ​​not equal to "Weekend") days given today's date?
5f5f5d8d01d13212799145.jpeg

Answer the question

In order to leave comments, you need to log in

3 answer(s)
N
Noir, 2020-09-14
@arr0w

=COUNTIFS(B1:B;"<>Weekend";A1:A;">="&today())
>= or > decide for yourself

K
keeplod, 2020-09-14
@keeplod

It is possible so)
5f5f652fdd257548898230.png
a link to the dock, although you did not give ...

G
Grigory Boev, 2020-09-14
@ProgrammerForever

Either COUNTIFS () or COUNT ( FILTER ())

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question