Referencing other sheets
I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs.
When I get to February, it tells me I am at the max for references. I think it was 15.
We have 7 squads...each squad seizes many drugs per month. I am trying to get the grand total of the drugs for all 7 squads for each month. I had a listing of drugs and then tried to add the squad totals to that.
Is there an easier way to do this?