K
K
ku4erena2014-09-29 14:03:54
Google
ku4erena, 2014-09-29 14:03:54

How to make two conditions in one cell?

Good afternoon.
Colleagues, tell me, please, how to make a formula of two conditions?
Namely, in my table (see the picture) I need to display the sum of hours for
1. a certain name of stage
2. and
432b83ffcd8f4b7ab82ece03e104942f.png
many thanks for the required month

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
mcroodberg, 2014-09-29
@ku4erena

If the Date column is replaced with the name of the month, then:
=sumifs(C2:C6; A2:A6; "=Procurement Planning"; B2:B6; "=June"
) I didn't figure out how to add the Month() function here.
For "deliveries" and "works" and the change of the month, you will have to manually change the condition.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question