I have a complex task. I need to total a column based on criteria in another sheet in the workbook. I have a sheet called CUSTOMER. In that sheet I have a column called RATE. If the rate = 1, then I need the customer number located in the first column. Based on that customer number, I need to go to the sheet called READING HISTORY and total all of the values in the USAGE column which are associated with that customer number (there may be up to 8). I also need to count the number of customer entries which were totalled. I can easily find the number of customers, but if a customer has 8 entries I need to count 8 not 1.
This board has done some amazing things in the past, I hope you can pull my butt out of the fire on this one.
This board has done some amazing things in the past, I hope you can pull my butt out of the fire on this one.