I'm trying to create a formula on excel where it will give the SUM of every 4th cell in a row. I have tried using just a simple =SUM() formula and clicking on each cell indivdually but this comes back with an error due to the number of individual functions (there are 47 in total). Is there an easy way of doing this?