I have two books.
Book ONE: has separate tabs by month.
Each individual inputs the products they sold each day of the month.
Book TWO: has separate tabs by week.
Each individual is manually adding the products sold and typing them in the respective category.
I think a SUMPRODUCT Array formula is best here.
Something that would calculate across sheets counting what product for each person per week of the month.
HELP??
Book ONE: has separate tabs by month.
Each individual inputs the products they sold each day of the month.
Book TWO: has separate tabs by week.
Each individual is manually adding the products sold and typing them in the respective category.
I think a SUMPRODUCT Array formula is best here.
Something that would calculate across sheets counting what product for each person per week of the month.
HELP??