SumIf with Date Range
I created a project management financial sheet (client / projects / deliverables & invoicing).
I am trying to sum the value of invoices between a date range (screen grab). This is what I thought would work:
and it returns "0"?
The reason for the blank DTI cells is that they are at the parent row level.
I also tried:
=SUMIF(DTI:DTI, MONTH(@cell) = 10, InVAT:InVAT)
and it returns "#INVALID DATA TYPE".
Idealy I would like to report on invoice forcast by month and invoices due by month...
Appreciate your advice and help in advance!