Which uses more processing power - countifs or index/match?

I was hoping that someone here will know which function uses more processing power.

I have four different countifs to collect data with each countifs having four different criteria. I’m adding the results of each countifs by connecting them with a plus sign.

In the same workbook, I need to split out the results of each of the four countifs in twenty-one tabs.

Would it be more efficient to use each of the four countifs once (in a helper tab) and then use index/match on the twenty-one tabs to bring the results in or have each tab reuse the countifs formulas?

Thank you for your input!

Use the helper column for the 4 COUNTIFS, then INDEX/MATCH.

Hope this helps.

Pete

FB - I forgot to add that each Division is broken down into districts (some as many as a hundred) and they want to know which districts have the most occurrences of each crime in each Division.

Each Division belongs to a group (four of them) and I already did the Citywide report which shows the worst five districts in each group. All that’s left to do is create each Division report now and then hand it over to them to use.

Thanks FB. I started that yesterday. As I thought about your first post, the more I liked having all the data manipulation in one place and then have 26 summary (or report) sheets (one for each Division, one for each group, and one for the whole city).

Thank you again for your insight!

DOH! Sorry about that Mr. Dibbins

The one sheet with the drop down is an intriguing thought. I could have them select the Division and then the sheet would auto-populate the stats for that division. There are 60 formulas for each report and I’ll have to lay down the data gathering and sorting first so I’ll know which cells to reference in the IF statements (those are going to be long IF statements too). The downside to that would be they would have to pdf each report individually to email it off. Having a sheet for each Division and group (Bureau) means they could batch pdf the reports for everyone all at once and send out one file (without having to assemble them in Acrobat).

I did three of the four Bureau reports today and I’ll do the fourth in the morning.

I’ll send them an email on Tuesday to see what their preference is. Thanks again for the ideas! I love this place, someone always has a way to do something that I hadn’t thought of.