| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding every third cell in a column
I need a formula for a cell that will add the value in every cell in a
specified column that has the name "Plan" in the cell in the previous column. |
|
#2
|
|||
|
|||
|
On Thu, 21 Apr 2005 14:23:02 -0700, "Jack Thiel"
wrote: I need a formula for a cell that will add the value in every cell in a specified column that has the name "Plan" in the cell in the previous column. Check HELP for SUMIF. If "Plan" may or may not be in Column A; and your values to be added are in Column C, then =SUMIF(A1:A1000,"Plan",C1:C1000) might work. If Column A contains Plan plus other stuff, then use wild card: "*Plan*" for example. --ron |
|
#3
|
|||
|
|||
|
That worked, Ron. Thanks much.
"Ron Rosenfeld" wrote: On Thu, 21 Apr 2005 14:23:02 -0700, "Jack Thiel" wrote: I need a formula for a cell that will add the value in every cell in a specified column that has the name "Plan" in the cell in the previous column. Check HELP for SUMIF. If "Plan" may or may not be in Column A; and your values to be added are in Column C, then =SUMIF(A1:A1000,"Plan",C1:C1000) might work. If Column A contains Plan plus other stuff, then use wild card: "*Plan*" for example. --ron |
|
#4
|
|||
|
|||
|
On Thu, 21 Apr 2005 14:59:06 -0700, "Jack Thiel"
wrote: That worked, Ron. Thanks much. You're welcome. Thank you for the feedback. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How do I copy every 8th cell in a column | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
