Google-sheets – How to add data in a specific row after searching a column for a specific keyword

You can filter column A by the location name, keep only the dates preceding the one in the current row, and take the maximum of those. Like this:

=iferror(max(filter(A$2:A, B$2:B=B2, A$2:A<A2)))

The formula shown is for the cell C2; it can be copied to the rest of the C columns.

• filter keeps only the dates prior to the current ones, where property name matches.
• max find the maximal (latest) of those
• iferror returns a blank (instead of an ugly #N/A error) when there is no prior date.

Be sure to format the columns A and C as dates.

Several Google Sheets built-in functions like SUM require that their arguments be numbers and if some of them are text in most of the cases they will return an error message. Exceptions are text values that could be coerced to numbers like numbers quote enclosed.

There are several built-in functions that could be used to handle unknown cell value types

• IFERROR If the first argument returns an error, returns the second argument
• ISNUMBER Returns true if the argument is a number value, false otherwise
• ISTEXT Returns true if the argument is a text value, false otherwise

the question doesn't include the expected result when the cells have a text value.

Let say that the expected result is 0, then we could use the following formula:

=IFERROR(SUM(D2,H2,M2),0)