V
V
Vlad M2015-05-16 20:23:08
Google
Vlad M, 2015-05-16 20:23:08

SUMIFS formula (google docs)?

e44d8bcdb91f4e60ad469c84655e5d77.png
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

1 answer(s)
V
Vlad M, 2015-05-16
@Vlad__M

part of the answer to this question is in the comments to this question How to correctly compose or what formula to use to calculate the amount according to a certain criterion (google docs)?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question