Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here are my formulas:
=SUMIF(D3:D33,"<8",D3:D33) =SUMIF(D4:D34,"8",D4:D34) I need to edit these to only sum the amounts that are over or under 8. For example, for the first formula, if there were 3 cells in this range that had the value of 5, then the result of the formula should show 9. For the second formula...;if there were 2 cells with the valud of 10 the result would show 4. I think I need to use MIN in there somewhere, but I'm not sure how. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif #value | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |