I have a report where I need to create a calculation to sum every other cell in a column. I was successful in getting results using the following formula =SUMPRODUCT((MOD(ROW($AM$11:$AM$500),2)=0)*($AM$11:$AM$500)) . I also tried using =MOD(ROW(AM9),AS2)=0.
Using the first formula I was able to match the sum that I have by selecting the cells manually for all of the even numbered row in the range. The second formula resulted in a 0 sum. My problem is that I have numbers in the odd cells that I need to sum as well. Is it possible to use either of the formulas from above to get the results without having to manually select the cells?