LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Sum every 6th cell in a row.

Hello,
I have read many posts summing every nth cell. I apologize - I am still
confused as I am still somewhat of an excel novice.

I have a workbook where I track financial details for multiple projects over
the course of a year. Every 5 rows contains all the details for 1 project.

Column C Represents January, Column D Represents February etc.

In C11 I want to SUM the Forecast for all projects in January,
In D11 I want to SUM the Forecasts for all projects in February.

My project data starts at C17:
Cell C17 is the name of the Project.
Cell C18 is the Forecasted $ amount
Cell C19 is the Actual Dollar Amount
Cell C20 is the Variance (Forecast -Actuals)
Cell C21 is the EAC

All of that starts over again at C22 for my next project.

Please help - What is the formula I want to put in C11?

I have copy / pasted / modified a variey of formulas I have seen posted - I
am not getting the correct value.

Thank you so much!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 [email protected] Excel Worksheet Functions 1 August 22nd 08 02:04 AM
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell [email protected] Excel Worksheet Functions 2 November 7th 07 09:39 AM
Inputting cell value from source cell based on value in adjacent cell. michaelberrier Excel Discussion (Misc queries) 3 December 9th 06 09:16 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D abmb161 Excel Discussion (Misc queries) 5 January 26th 06 06:36 PM
Cell Formula reference to cell Based On third Cell Content Gabriel Excel Discussion (Misc queries) 0 February 11th 05 05:35 AM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"