Vlookup I think

[vavs]

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.

 

[Aladin Akyurek]

It might help if you could provide 2 5-row samples from those two sheets.