Sum Multiple Different Ranges or Conditions

Hello again!

I am trying to sum values in a column over different ranges. For example, I have 2500 values but want to sum every 50 values together. I was thinking about summing using conditions in another column. Like if the values in column A=0 and B=0 then sum corresponding values in column C and place sum into column D. Then if A=0 and B=1 and so on. A would go from 0-5 and B would go from 0-9.

Not sure if I should try an array here (haven't worked with them before) or a sumif in VBA (can you do that??).

Thanks in advance!

You can SUMIFS via formula if you're open to that suggestion.

If you have a header row, and your data begins in A2 and B2, then C2 would like like:
=SUMIFS(C:C,A:A,0,B:B,0)

Does something like that help?

Sorry for the delay - I am trying to stick with Macros instead of formulas since I eventually will have one giant macro in the end. I think there is a way to SUMIF in a macro. I just need to do a little more research.