Countif function

D

David Harrison

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
 
S

Stefi

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:
 
R

Ron Rosenfeld

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
Click to expand...

Something like:

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


--ron
 
Top