| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with sum if function
How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
Do you mean Rows O20 to O33, if so try:-
=IF(C14="N",SUM(O23:O33),"") Mike "bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
I have the following formulain my worksheet...
=IF(C14="N",SUMIF(O20:O33,"Float. Hol/B-day",N20:N33),"0") Any idea why it won't work? In column N20 to N33 there is an 8 which should appear in cell C54. "Mike H" wrote: Do you mean Rows O20 to O33, if so try:- =IF(C14="N",SUM(O23:O33),"") Mike "bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
Works for me .... check the text string ,"Float. Hol/B-day" is correct and/or
data in N is numeric not text. "bl_johnson_19" wrote: I have the following formulain my worksheet... =IF(C14="N",SUMIF(O20:O33,"Float. Hol/B-day",N20:N33),"0") Any idea why it won't work? In column N20 to N33 there is an 8 which should appear in cell C54. "Mike H" wrote: Do you mean Rows O20 to O33, if so try:- =IF(C14="N",SUM(O23:O33),"") Mike "bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
I went ahead and entered the formula below, which is working o.k. but when I
take the same formula, and change the IF($C$14="D" to "N".. it will not work. It DID work the first time I put the formula in... =IF($C$14="D",SUMIF($O$20:$O$33,"Float. Hol/B-day",$N$20:$N$33),"") "Mike H" wrote: Do you mean Rows O20 to O33, if so try:- =IF(C14="N",SUM(O23:O33),"") Mike "bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
I went ahead and entered the formula below, which is working o.k. but when I
take the same formula, and change the IF($C$14="D" to "N".. it will not work. It DID work the first time I put the formula in... =IF($C$14="D",SUMIF($O$20:$O$33,"Float. Hol/B-day",$N$20:$N$33),"") "Mike H" wrote: Do you mean Rows O20 to O33, if so try:- =IF(C14="N",SUM(O23:O33),"") Mike "bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
=IF(C14="n",SUM(o20:o33),"")
"bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with sum if function
=(C14="N")*SUM(O20:O33)
"bl_johnson_19" wrote: How can i use sum if function to sum numbers in columns O20:O33 only if cell C14 has a "N' in it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
![bl_johnson_19[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
