| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Non-Continuous Range
This SUMIF function isn't working. Is it the non-continuous range it doesn't
like? =SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF Non-Continuous Range
Wouldn't the following suffice?
=SUM(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD38) Hope this helps! In article , Kirk P. wrote: This SUMIF function isn't working. Is it the non-continuous range it doesn't like? =SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF Non-Continuous Range
Yes it does suffice, I realized almost immediately after posting the question
it was a dumb question! "Domenic" wrote: Wouldn't the following suffice? =SUM(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD38) Hope this helps! In article , Kirk P. wrote: This SUMIF function isn't working. Is it the non-continuous range it doesn't like? =SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| for SUMIF function, how do I use 2 sets of range & criteria | Excel Worksheet Functions | |||
| SumIf in Visible Cell Range | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Linear Mode
