Answer the question
In order to leave comments, you need to log in
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
many thanks for the required month
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question