Search code examples
google-sheetsgoogle-sheets-formula

Use infinite row argument in ISDTATE function

I am using the sumifs formula to check for two conditions.

=sumifs('Invoices Sent'!K:K,'Invoices Sent'!B:B,"<"&B17, 'Invoices Sent'!O:O,">="&B18)

I want to add the third condition that the value in cell in column 0 is a date. How do I format this condition for the sumifs function? I think ISDATE can only take a cell.

=sumifs('Invoices Sent'!K:K,'Invoices Sent'!B:B,"<"&B17, 'Invoices Sent'!O:O,">="&B18, 'Invoices Sent'!O:O,ISDATE())

I need to use infinite rows as I don't want to keep changing the formula each time I add a row. By infinite rows I mean, a start and end row index is not specified.

Any help would be appreciated !

Solution

  • Add this as the third condition within your sumif(); also assuming your Column O has valid date-format

    index(isdate_strict('Invoices Sent'!O:O)), true