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
|