Hi,
I have data arranged in 3 columns:
Column A - daily dates
Column B - product names
Column C - revenue for product
On any given date there may be multiple sales of a particular product. I would like to set up a table that sums the total revenue per product per day, based on a formula that looks at columns A to C as described above. I know that I could do this with a pivot table but would prefer to use a formula.
Could someone please suggest how I can do this by taking both criteria (date and product name) into account?
Thanks!
Bookmarks