Hello,
I have several massive spreadsheets that I need to analyze using the COUNTIFS function, but right now the only way I know how to do that is by changing the data range for each cell. For example, I am using the function =COUNTIFS(A:A,">0",A:A,"<5") for the first cell, and then =COUNTIFS(A:A,">5",A:A,"<10"), =COUNTIFS(A:A,">10",A:A,"<15") and so on. Is there a way do it so I could just specify to count every 5, and excel would autofill 0-5, 5-10, 10-15, etc.?
Excel screenshot.jpg

Thank you!