SUMIFS formula picking up all values instead of criteria

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd

I have two columns.
First column =age of invoice
Second column = $

I want to do SUMIFS for invoices > 365 days

E6 works fine for invoices 'Not Due'
E7 should pick up $0.00 but instead picks up everything

Not sure why..

 

[Michael M]

Try using

=SUMIF($A:$A,D3,B:B)

 

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngUe3UvSuAukaSiqO?e=SlIJFL

Ok, I made my example clearer

If I filter by Not Due, 4 to 5 days etc, it calculates the correct total

But when I choose >365 days, it picks up the grand total. Anyone know how to make it calculate zero, as per the data?

 

[Michael M]

Use instead

=SUMPRODUCT(--(A3:A6=D3),B3:B6)

 

[danhendo888]

Works beautifully, thank you very much Michael