| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with SUMIF
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
Kerri
not sure I understand what you want but, maybe this: =IF(SUM(E18:E23)0,SUM(E18:E23)-40,0) Regards Trevor "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
I think the formula was correct with the exception of the greater than
number. This should be it. =IF(SUM(E18:E23)40,SUM(E18:E23)-40,0) "Trevor Shuttleworth" wrote in message ... Kerri not sure I understand what you want but, maybe this: =IF(SUM(E18:E23)0,SUM(E18:E23)-40,0) Regards Trevor "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
I'm just gonna have to get that key fixed.
Thanks "PCLIVE" wrote in message ... I think the formula was correct with the exception of the greater than number. This should be it. =IF(SUM(E18:E23)40,SUM(E18:E23)-40,0) "Trevor Shuttleworth" wrote in message ... Kerri not sure I understand what you want but, maybe this: =IF(SUM(E18:E23)0,SUM(E18:E23)-40,0) Regards Trevor "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
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 |
|
#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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
I'd check your data. Maybe you've got text that looks like a number and
isn't getting added in. Maybe one that looks like 4.5 ? Could be a space in there somewhere ? Regards Trevor "Kerri Olsen" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
That is exactly what I gave you!
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
-- Kerri "Bob Phillips" wrote: That is exactly what I gave you! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with SUMIF
Thank you, it worked in another part of my work sheet, not where I want it
to, could be the formating of some of the data. Thank you -- Kerri "Kerri Olsen" wrote: -- Kerri "Bob Phillips" wrote: That is exactly what I gave you! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
| Reply |
| 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) | |||
Hybrid Mode
