Attached is a sample of a workbook I am trying to get totals for. I tried using Index and Match but keep getting an error message saying there is too many criteria. I want to be able to have column F on the sheet 'Reports' bring up a total for whatever criteria is selected from the drop downs in Columns A-E (pulling data from the first few worksheets). Does anyone know how to do this?
Thanks!
Bookmarks