test for excel forum.zip
Please Help!
I am trying to Sum the Total usage -BY LOCATION - From Sheet 1 (copier Meter Log), to Sheet 2 (Usage Reference Tab).
For Example, Sheet 2 D11 Should be the sum of all B&W Total Usage on Devices for Canada Only. Sheet 2 D12 Should be for Canton etc.
I have created Column D on Sheet 1 with a header "B&W Location". Each time a location is seen, as you scroll down the column, I need excel to go over "X" number of columns and return the summed value for that month, at that particular location, every time it comes across tha location in column D.
Note: I would like to select the "Month Number" (Sheet 2 D6), and have the totals for that month displayed.
Any Help would be greatly appreciated! Please let me know if I need to clarify further...
Another note. I am not comfortable with VB or Macros, I am just looking for a possible formula...
Bookmarks