Error on index and match

[elricsia]

Hi all,

I don't know which part of formula (some one provided and modify by myself) is going wrong. I looking for the negative values from my stock. But when i key in positive value on the same date, the negative value will not be shown.

Please help on this formula.

Thank you.

[samba_ravi]

In your sheet where you are getting error

[S O]

You don't need an array formula, just use a =SUMIFS

For example in K5 enter this:
=SUMIFS(Table1[[Amount]:[Amount]],Table1[[Date]:[Date]],K$4,Table1[[Company]:[Company]],$J5,Table1[[Amount]:[Amount]],"<0")

And then copy across and down as needed

[elricsia]

Sorry for my mistake!

Please look up K4:W4 for the error. When i key in the same date (5, 7, 11 & 21/Apr) with negative value the date will not show up.

Thank you.