Hi,

I cant get to a simple solution for this question I have???
I have a list of customers
I have a list of products and qtys sold
I have a list of dates(period)
I have a year

what I want is to sum the products sold to all customers EXCEPT a list
then report by period and year.

using sumifs does the trick except I would need to specificy each customer to exclude and reduce them from the total amount.gotta be a simpler smarter way????

test sheet.xlsx