Answer the question
In order to leave comments, you need to log in
SUMIFS formula (google docs)?
can you tell me? the formula will be used by the SUMIFS criterion by date, how to select the range of the criterion is understandable, but the criterion itself (column F in the screenshot above), more precisely, I can’t understand how to enter its value, I need the month and year to be counted by coincidence, for example "=05.2015 "and in the cell itself is, for example, 05/16/2015 i.e. in theory there should be something like this "=*.05.2015" - how to do it right?
the formula is accepted anyway, but does not count, it counts only by complete coincidence on 05/16/2015, but it is necessary that by 05/2015
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question