I know that the answer to this is really pretty simple. since what I am
trying to do is really so simple but I can't make it work. I wrote a if
formula that enters a value into a cell under specific sonditions and then I
want to sum that column of calculated values into one cell at the bottom of
that column and it won't work. If I manually enter a value in the cell in
the column it sums in the bottom cell. but a calculated value will not sum
into the cell. whats up.

Leonard