| Home |
| Search |
| Today's Posts |
|
#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. |
| 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)
Threaded Mode
