HI there. attached is an example file. I tally up sales by quarter, by customer...very straight forward. However, when I wan to find out the NEW Customer business and NEW customer accounts, it gets complicated b/c i have customers that are re-ordering and those re-orders don't constitute a new customer anymore or new sales. I typically do this by counting long way with a lot of sorting and visual looks. How can i speed this up without using VBA, I'm not good at VBA. Customer column = A, fiscal quarters Sales run from B:Q, grand total = R. Much appreciated. Kb

Account 2013-Q2 2013-Q3 2013-Q4 2014-Q1 2014-Q2 2014-Q3 2014-Q4 2015-Q1 2015-Q2 2015-Q3 2015-Q4 2016-Q1 2016-Q2 2016-Q3 2016-Q4 2017-Q1 Grand Total
HSBC $493 $560 $1,053
PepsiCo $154 $250 $559 $963
Google $532 $378 $910
Kellogg Company $350 $533 $883
BMW $347 $501 $848
Honda Motor Company, Ltd $275 $515 $790
Porsche $125 $595 $720
Louis Vuitton $225 $457 $682
eBay $528 $123 $651
Pizza Hut $311 $315 $626
Credit Suisse $586 $586
Yahoo! $585 $585
Jack Daniel's $581 $581
Starbucks $558 $558

Count of new customer in period
Sum total of new business in Period