Summarising Data by Date and Product Code

[Mark266]

Hi All

I would like to summarise data by date and also product code. I am sure it is easy, but cant seem to work out the best way.

I have attached a copy of a small sample of data.

If anyone could help it would be appreciated!

Thanks

[FDibbins]

Hi, welcome to the forum

NOte that the "numbers" in column K are actually text, not numbers.

See if this is what you want?
=SUMIFS($J$5:$J$27,$H$5:$H$27,B$4,$K$5:$K$27,TEXT($A5,"0"))

[oeldere]

With an pivot table.

See the attached file.

[Mark266]

Hi Ford

Thanks for the reply, unfortunately doesn't seem to work for me, just comes up with error #NAME?

I have tried making sure both product codes are Text values but no joy.

Regards

Mark