View Single Post
 
Old 01-29-2015, 10:19 PM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default CountIF Functions

I have countIF Functions in my spreadsheet for Customer, Industry and Level. My countif functions are on a worksheet and updating every time I add to the worksheet. Is there a way with countif to drill down to the Customers who fall under that Industry. I know I can use a pivot table to calculate total and drill down, but I do not want to remember to have to refresh every time the data updates. I am not the only ones using the report.
Reply With Quote