Need for formula to count and grouping for google sheet

Anyone can help. Need guide to count item and group by date & item.
ITEM SHOW A,B,C,D BUT ONLY COUNT FOR A,B & C.

Screenshot .jpg

if you restructured your data as in the screenshot, you could use this formula (example in cell G2, then drag down to other rows, and then drag the column across until column I):

Please Login or Register  to view this content.

Attachment 744457

See the attachment for screenshot