| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to put ranges in Criteria..
For a SUMIF formula I need to have a numerical range for the criteria. Is
this possible? It has to be a solution that lets me add up the numbers in one column IF the criteria is met..... Thanks for all input!! |
|
#2
|
|||
|
|||
|
You can use two SUMIFs in a formula, e.g.:
=SUMIF(B2:B28,"40")-SUMIF(B2:B28,"80") Steve wrote: For a SUMIF formula I need to have a numerical range for the criteria. Is this possible? It has to be a solution that lets me add up the numbers in one column IF the criteria is met..... Thanks for all input!! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Thanks......proof there is always a couple of ways to skin a cat...
"Debra Dalgleish" wrote: You can use two SUMIFs in a formula, e.g.: =SUMIF(B2:B28,"40")-SUMIF(B2:B28,"80") Steve wrote: For a SUMIF formula I need to have a numerical range for the criteria. Is this possible? It has to be a solution that lets me add up the numbers in one column IF the criteria is met..... Thanks for all input!! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF criteria using date ranges? | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
