Countif function
 

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

Hi David,

It isn't quite clear what you want to do. If I understood well, that you
want to sum values in range C4:C33 provided their corresponding cell's value
in column F in the same row is greater then 8, the the formula in cell D36 is
=SUMIF(F4:F33;"8";C4:C33)

Regards,
Stefi

€žDavid Harrison€� ezt Ã*rta:

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

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