On Fri, 16 Sep 2005 03:17:08 -0700, "David Harrison"
wrote:

ok, here we go

C4:C33 is a list full of currency values. F4:F33 is full of number ranging 1
to 9.

In cell D36 i would like to add up all the values that are above the no. 8
from col C.

How do i do this?

thanks


david

Something like:

=SUMIF(F4:F33,"8",C4:C33)


--ron