Calculate Every 4th Cell Down!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey!

Need something that will Calculate evrey 4th cell without using this long
process formula because this is required down the whole sheet.

=C9+C13+C17+C21

Example:

Total = 9

C9 = 1
C13 = 1
C17 = 5
C21 =2
 
You can try this:
Create a helper cell in Column D.
In Cell D9, enter this formula: =IF(MOD(ROW()-5,4)=0,C9,"-")
Copy downwards.

HTH.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortening or changing a formula 7
Concatenate problem 7
calculate how many Mon, Tue, Wed, Thur, Fri, Sat & Sun in month 1
Code to Implement Required Cells Not Working 3
Formula 5
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13
Help: How do I create a column of fixed width data? 1
Auto Fill Links with a Pattern 1

Back
Top