- Jun 18, 2014
I have a sheet that contains daily sales by code for about 100 different codes. On another sheet I want to show the sales by week number and year. I have already put formulas in place on the daily sales sheet to show the week number, day and year from the date cell. But I cannot get any formula to find a total weeks sales, I have tried using sumifs and match formulas but nothing works. The formula needs to match the code, the week number and the year and total up the seven days for that week. Any ideas???