Formula to find Data and Corresponding date and return total sales and total units per item

[KimPansegrauw]

Hi All, i have an excel spreadsheet that runs with sales MTD, i am trying to create a snapshot where we match all sales for a specific item for a date and return the total sales in Rand value and in the next column return the total quantity of units sold for that particular item
i cant install the upload mini sheet - keep getting an error message

i would like to be able to calculate in 1 column - how many "banana 20kg (40x 50g) were sold on each day and in the 2nd column i would like to calculate the total sales for each day

New Data Template example - still working on this

 

[kvsrinivasamurthy]

Names in column A of both the tables must exactly match. Then only formula works.

 

[RoryA]

A pivot table would be the simplest option.

 

[KimPansegrauw]

A pivot table would be the simplest option.

Thank you, i watched the video, however i get the following error, so i dont think it can be installed
None of my files are in protected View

 

[RoryA]

The links in my signature have nothing to do with pivot tables or my suggestion (they are about installing the forum's XL2BB add-in)