ExcelBanter - How to put ranges in Criteria..

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to put ranges in Criteria.. (https://www.excelbanter.com/excel-discussion-misc-queries/44512-how-put-ranges-criteria.html)

Steve

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!!

Debra Dalgleish

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

Steve

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

All times are GMT +1. The time now is 03:57 AM.