Pivot Column monthly totals not excluding blanks

Apologies if this has been covered already, but could not find anything on here.

Attached lists three hundred payments against invoices raised by companies.

Col E shows one hundred and forty seven of them were not paid within thirty days, so were "overdue" when paid.

Using Formulae, the Graph in rows 1 - 14 summarises the totals and the Table in rows 17 - 22 summarise invoices by month perfectly.

But I can't get the same result on the Pivot Table in rows 24 - 29. It lists ALL the three hundred transactions, even though it is linked to Col E?

All solutions, suggestions and alternatives welcome as ever.

Ochimus

Bo_Ry,

Many thanks both for the solutions offered, which (even if inadvertently) gave me the solution!

Because your revised formula in Col D generates blanks, 'right-clicking' the Overdue field setting (renamed 'Late payment by customers') enabled me to select 'Count Numbers', not Count, which ignores the blanks and gives the correct result, as shown on the attached.

"ex Excel semper aliquid novi”, as Pliny the Elder would have said if we'd had it two thousand years ago!

Ochimus