Excel Forum
Similar Content
Increment a Date By X Days for Each Row in Excel
Tutorial: How to quickly increment a date by a certain number of days for each entry. Type the first...
SUBTOTAL Function - Work on Filtered Data in Excel
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...
CHOOSE Function in Excel
Tutorial: Return a value from a list of values. This is like a mini-lookup function that contains a...



Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product


See how to use SUMPRODUCT or COUNTIFS Functions to count how many sales you made for a given product over the last 7 days. This is a counting with two 2 criteria problem. Function formula





Got a Question? Ask it Here in the Forum.