| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with SUMIF
I am getting 0, when is should be 4.5
-- Kerri "PCLIVE" wrote: The formula provided should do that. What are you getting? "Kerri Olsen" wrote in message ... I guess my question is not clear if sum of E18:E23 is over 40, I want the difference entered in the cell, example total is 46 I want 6 in cell if sum of E18:E23 is 40 or less, I want 0 -- Kerri "Bob Phillips" wrote: I think Trevor's should be =IF(SUM(E18:E23)40,SUM(E18:E23)-40,0) and here is an alternative =MAX(SUM(E18:E23)-40,0) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kerri Olsen" wrote in message ... I need help writing a formula if range E18:E23 is greater than 40, I want the number E18:E23-40 entered into the cell, if false 0 -- Kerri |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Help with SUMIF function | Excel Worksheet Functions | |||
| Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
| SUMIF | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
