Comparison of dates if reference cell is empty

[cobra2008]

I have the below formula:

= SUMPRODUCT ((YEAR ('Database Statistics'! $ F $ 2: $ F $ 999) <= $ A31) * ('Database Statistics' "T $ 2: T $ 999))-SUMPRODUCT ((YEAR ( 'Database Statistics'! $ G $ 2: $ G $ 999) <= $ A31) * ( 'Database Statistics' "T $ 2: T $ 999))

making a total of T column for years at or below a reference year in column A and subtracted from the total values of column T if in column G, a date entered is equal to or less that same year reference.

This works, provided in column G, all dates are informed.

Currently, this column is partially filled with a date 31/12/2025, but to avoid this "trick", I would do without my dates and leave empty if they are not really valid.

[Blazej]

Try adding the condition of the cell is not empty.

= SUMPRODUCT ((YEAR ( 'Database Statistics'! $ F $ 2: $ F $ 999) <= $ A31) * ( 'Database Statistics' "$ G $ 2: $ G $ 999> 0) * (YEAR ( 'Database Statistics'! $ G $ 2: $ G $ 999) <= $ A31) * 'Database Statistics' "T $ 2: T $ 999)

[cobra2008]

I also tried adding a SUMPRODUCT to test this condition, but still the same issue. Basically, in the sheet if the empty cells in column G are complemented with a "bogus" date (31.12.2025 emerging from a comparison) then it is ok, columns B through F to the piece Statistics return the correct values. If not informed, the results are not valid.

[Blazej]

Then i think you should try this:

= SUMPRODUCT ((YEAR ( 'Database Statistics'! $ F $ 2: $ F $ 322) <= $ A6) * 'Database Statistics'! S $ 2: S $ 322) - SUMPRODUCT(( 'Database Statistics' "$ G $ 2: $ G $ 322> 0) * (YEAR ( 'Database Statistics' "$ G $ 2: $ G $ 322) <= $ A6) * 'Database Statistics'! S $ 2: S $ 322)