Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
COUNTIF and then SUM in Same Function | Excel Worksheet Functions | |||
A COUNTIF function Challenge | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions |