Aggregating Columns In Excel

Aggregating Columns In Excel

I have data consisting of a date and a list of purchases, something like
this (commas represent separate columns):
date,product1,product2,product3
08/11/13,oranges,apples,chips
08/11/13,grapes,oranges
08/12/13,grapes,pineapples
08/12/13,grapes,oranges
I want to know how many items of each product were purchased on each date
(and plot it). So if I had a single product column it would be pretty
simple, I could just use a pivot table. However in my case, for August
11th, I need a way of counting the "oranges" from product1 together with
the "oranges" from product2... One way would be to duplicate rows and
translate the data to a single column, but I'd like to avoid it.
Is there a way to do that, preferably without the use of VBA?